RE: Handle where in clause

[Walther . HAUTERMANN]

        <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: '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.