<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:[EMAIL PROTECTED]
Sent: Tuesday, March 22, 2005 12:56 PM
To: '[email protected]'
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.
