Hi Eugeny, I placed the list in a map coz., i wanted to pass more parameters.
<select id="getShopByDPCValueAddedMemberId" resultMap="shopIdNameResult" parameterClass="map"> select TBLSHOPS.SHOPID, TBLSHOPS.SHOPNAME from TBLSHOPS, TBLSHOPGROUPS1 where <iterate open="(" close=")" conjunction="OR" property="dpcvamlist"> TBLSHOPGROUPS1.GROUPID = (#dpcvamlist[]#) </iterate> and tblshops.active = 'Y' and TBLSHOPGROUPS1.shopid = tblshops.shopid </select> But did you try to just pass the list. It would work. Use (#value[]#) Rgds Prashanth. --- Eugeny N Dzhurinsky <[EMAIL PROTECTED]> wrote: > On Mon, Aug 08, 2005 at 04:29:42PM +0200, Niels Beekman wrote: > > Something like this: > > > > class MyBean { > > public List getList() { > > return mylinkedList; > > } > > } > > > > <iterate property="list" open="(" close=")"> > > #[]# > > </iterate> > > > > When passing the list directly as argument use: > > > > <iterate open="(" close=")"> > > #[]# > > </iterate> > > Hope this helps, > > Niels > > Umm, so there's no way to operate with the "clean" lists, i need to wrap the > list in the bean :(? > > -- > Eugene N Dzhurinsky > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com