ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Diran Ayandele <Adediran.Ayand...@Sun.COM>
Subject Re: IN (SQL), how to iterate?
Date Wed, 14 Jun 2006 22:48:24 GMT
Hmmm, try the documentation it will be a short search for you and worth 
your time to read them over.
- look for the iterate tags:

Or for java -> http://ibatis.apache.org/javadownloads.html



xianwinwin wrote:

>can anyone provide an exmple of how to use this statement with iBatis?
>
>    	SELECT name,branch,username 
>        FROM KXAccount
>    	WHERE id IN ('234','655','411','775,'416')
>
>the problem is in the IN clause: when I try this:
>
>    	    	SELECT name,branch,username 
>                FROM KXAccount
>    	        WHERE id IN (#ids#)
>
>I try this and while popuplating the #ids# with a string of:
>'234','655','411','775,'416' 
>the result applies only to the first item (234).
>
>does anyone know any exmple of IN which iterate through the object?
>thanks
>
>
>--
>View this message in context: http://www.nabble.com/IN-%28SQL%29%2C-how-to-iterate--t1789058.html#a4874196
>Sent from the iBATIS - User - Java forum at Nabble.com.
>
>  
>

Mime
View raw message