Never used something like that, but there is an <iterate> tag for dynamic
sql. In your case and in my opinion the best solution is through a join:
select * from employee where employeeid in (select id, name from your other
query)

Greetings!

Greetings!

On Mon, Aug 3, 2009 at 12:41 PM, sanjeev40084 <sanjeev40...@hotmail.com>wrote:

>
> I have a query which returns lists of object(id, name). Can i pass this
> object in my ibatis and use it as parameter. i.e
> select employee, year, department
> from Employee
> Where EmployeeID = #id    <--id is from the list which i populated earlier
>
> Any clue??
> --
> View this message in context:
> http://www.nabble.com/Use-list-of-objects-as-parameter--tp24794045p24794045.html
> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-cs-h...@ibatis.apache.org
>
>

Reply via email to