help in executing a query

[ashishvk <as...@infosys.com>]

which is the best way of executing the following query in ibatis

select * from address where country_id in {<list of countries>} and state_id
in {<list of states>} ;

thanks
ashish
-- 
View this message in context: http://www.nabble.com/help-in-executing-a-query-tp15950565p15950565.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

RE: help in executing a query

[Meindert <me...@pastelebusiness.com>]

The iterate tag would do that (read the list and put it in your where
clause).


-----Original Message-----
From: ashishvk [mailto:ashishvishwas_k@infosys.com] 
Sent: Monday, March 10, 2008 8:19 AM
To: user-java@ibatis.apache.org
Subject: help in executing a query


which is the best way of executing the following query in ibatis

select * from address where country_id in {<list of countries>} and state_id
in {<list of states>} ;

thanks
ashish
-- 
View this message in context:
http://www.nabble.com/help-in-executing-a-query-tp15950565p15950565.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.