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 Adnan Atic <Ad...@hilton.com> on 2007/01/11 21:36:22 UTC

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

RE: IN - representation in IBATIS

Posted by Poitras Christian <Ch...@ircm.qc.ca>.

Look at the iterate tag.
 
Christian

________________________________

From: Adnan Atic [mailto:Adnan_Atic@hilton.com] 
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