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.
