IN (SQL), how to iterate?

[xianwinwin]

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.