| I would not suggest this method. You would have to worry about sql injection and the loss of ibatis typing. I would use the iterate tag.
Nathan On Jun 15, 2006, at 10:33 PM, puneet arya wrote: hi, SELECT name,branch,username
FROM KXAccount
WHERE id IN (#ids#)
You can write in xml as SELECT name,branch,username
FROM KXAccount
WHERE id IN ($ids$) and in these id you have to capture as a string . if u didnt get , you just tell me teh full scenario i will give you the exact solution.
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
Send instant messages to your online friends http://in.messenger.yahoo.com
Stay connected with your friends even when away from PC. Link: http://in.mobile.yahoo.com/new/messenger/
Yahoo! India Answers: Share what you know. Learn something new Click here
Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now
|
