INCLUDE

[Timo Schnölzer]

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   [EMAIL PROTECTED]
_________________________________________________
 
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.
 
 
