Re: SQL question with where in clause

[Thorbjørn Ravn Andersen <thunderaxiom@xxxxxxxxx>]

Ashish Kulkarni skrev  den 13-09-2007 20:35:
> Hi
> 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 ?
If you want to use PreparedStatements you cannot do it like this.  Each 
? can only correspond to a single value.

You can - however - have a list of  PreparedStatements with one, two, 
three, four, five.... whatever parameters respectively.  Then use the 
one you need.
--
 Thorbjørn