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 > >