ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xianwinwin <xianwin...@gmail.com>
Subject IN (SQL), how to iterate?
Date Wed, 14 Jun 2006 22:38:52 GMT

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