yes, look into the <iterate> tag of the dynamic sql. It's all in the user guide.
Hope that helps, Brandon On Wed, 9 Mar 2005 15:02:34 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Hi, > > I would like to have in an sqlMap a select like this : > > SELECT * FROM OPERATIONS WHERE OPERATION_ID IN (1,3, 7, 9) > > I can't find a way to specify the list of values in the where statement. > > Is it possible? How do you do that? > > Thanks > Walther
