You need to add a question mark for each parameter in the IN, like IN({1}, {2}, {3})
If the number of parameters can vary at runtime you need to use dynamic queries. It is
covered in JBossCMP docs.
<a
href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3825480#3825480";>View
the original post</a>
<a
href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3825480>Reply
to the post</a>
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
