ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Walther.HAUTERM...@cec.eu.int
Subject RE: Handle where in clause
Date Tue, 22 Mar 2005 12:09:20 GMT
	<select id="getValidCoupon" parameterClass="java.util.List"
resultClass="map">
		select productId, ID
			from table			WHERE p_id IN
				<iterate open="(" close=")" conjunction=",">
					#[]#
				</iterate>
	</select>

-----Original Message-----
From: Steven Pannell [mailto:steven.pannell@zooplus.com] 
Sent: Tuesday, March 22, 2005 12:56 PM
To: 'ibatis-user-java@incubator.apache.org'
Subject: Handle where in clause


Hi,

Is there an easy way to handle the where in SQL clause like:

	<select id="getValidCoupon" parameterClass="array??"
resultClass="map">
		select productId, ID
			from table
		where p_id in ( #list of values# )
	</select>

Thanks,
Steve.

Mime
View raw message