Re: IN (SQL), how to iterate?

[RZG]

 eg sql:

  

    SELECT name,branch,username
               FROM KXAccount
               WHERE id IN (#ids#)

 you can write as this:

 

 

    SELECT name,branch,username
               FROM KXAccount

   <iterate prepend="where" property="ids"open=" id in (" conjunction="," close=")" >
    #ids[]#
   </iterate>

 

2006/6/15, xianwinwin <[EMAIL PROTECTED]>:

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.

--
RenZenggang
[EMAIL PROTECTED]
[EMAIL PROTECTED]
MSN:[EMAIL PROTECTED]
Blog: http://rzg.itpub.net