In official iBatis distribution, there is a PDF file documentation. On
pages 47-49 it talkes about dynamic mapped statements. You probably
want to take a closer look at page 49 and use iterator (hint).
-adam
On 9/13/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> 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 ?
>
> 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
>
>
> Ashish
>
>
