ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Zimowski" <zimowsk...@gmail.com>
Subject Re: Question about SQL
Date Thu, 13 Sep 2007 19:07:59 GMT
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 <ashish.kulkarni13@gmail.com> 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
>
>

Mime
View raw message