You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Timo Schnölzer <ts...@nsdcom.de> on 2006/11/24 18:47:08 UTC
INCLUDE
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.