ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashish Kulkarni" <ashish.kulkarn...@gmail.com>
Subject Question about SQL
Date Thu, 13 Sep 2007 18:33:41 GMT
I have a sql statment like

select * from mytable where line in ('ABC', 'XYZ')

where this SQL
statement is going to extact all rows where line is ABC and XYZ,

but now the problem is i do not know if there are going to be only one line
or 2 or 10, so i thought i would define the sql as

select * from mytable where line in ?

and then i created a string like ('ABC', 'XYZ') and passed it as input
parameter, but it does now work,

Any ideas for a work around this solution


View raw message