RE: IN - representation in IBATIS

[Poitras Christian]

Look at the iterate tag.
 
Christian

________________________________

From: Adnan Atic [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 11 January 2007 15:36
To: user-java@ibatis.apache.org
Subject: IN - representation in IBATIS


I am not sure how to represent this SQL construct in ibatis sql config
files :
 
SELECT A.* 
    FROM USER A 
 WHERE TYPE IN (?,?,...)
 
Is there something like:
<select id="getUsers" resultMap="userResultMap"
parameterClass="java.util.List">

SELECT A.* 
    FROM USER A 
 WHERE TYPE IN (#types#)

</select>

 

Thanks