ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Timo Schnölzer <tschnoel...@nsdcom.de>
Subject INCLUDE
Date Fri, 24 Nov 2006 17:47:08 GMT
Hi Folks,

I have to include lots of sql parts into a select statement. These parts follow a rule and
I want to use

<include refid="#partSpec#_part" /> or <include refid="$partSpec$_part" />

Is there a way to do this???

Thx for info

Timo

Here is my example:

	<select id="getObjectListByFilter"
		resultClass="java.util.HashMap">
		SELECT DISTINCT #returnType#,
		<isEqual property="returnType" compareValue="typinfo">
			vehicle_id,
		</isEqual>

		e.schema_id, e.data_value AS VALUE, (SELECT full_text FROM
		schema_text t WHERE t.schema_id = e.schema_id AND t.data_value =
		e.data_value AND language_id = 35) AS label FROM equipment e
		WHERE e.schema_id IN (
		<isEqual property="returnType" compareValue="typinfo">
			<include refid="typinfo_part" />
		</isEqual>
		<isEqual property="returnType" compareValue="fabrikat">
			<include refid="fabrikat_part" />
		</isEqual>
		<isEqual property="returnType" compareValue="baureihe">
			<include refid="baureihe_part" />
		</isEqual>
		<isEqual property="returnType" compareValue="aufbauart">
			<include refid="aufbau_part" />
		</isEqual>
		<isEqual property="returnType" compareValue="abgas">
			<include refid="abgas_part" />
		</isEqual>
		<isEqual property="returnType" compareValue="antriebsart">
			<include refid="antriebsart_part" />
		</isEqual>
		<isEqual property="returnType" compareValue="fahrzeugart">
			<include refid="fahrzeugart_part" />
		</isEqual>

Mit freundlichem Gruss
 
NSD Communication Consulting GmbH 
 
 
 
 
Dipl.-Kfm.
Timo Schnölzer
(Geschäftsführer)
 
 
 
_________________________________________________
NSD Communication Consulting GmbH
Ludwig-Erhard Str. 8
45891 Gelsenkirchen
 
Telefon  +49.209.94041.40
Fax      +49.209.94041.99
e-mail   timo.schnoelzer@nsdcom.de
_________________________________________________
 
Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen.
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, 
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. 
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
 

This e-mail may contain confidential and/or privileged information. 
If you are not the intended recipient (or have received this e-mail in error) 
please notify the sender immediately and destroy this e-mail. 
Any unauthorized copying, disclosure or distribution of the material 
in this e-mail is strictly forbidden.
 
 


Mime
View raw message