The substituted values get quoted, so the query actually will read as
SELECT DISTINCT city
| FROM UsaZipCode
| WHERE statecode = 'NJ' AND county IN ('Morris,Essex') AND citytype = 'D'
| ORDER BY city;
(note the position of the quotes in the substitution of the second '?')
This explains why a single element works.
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3847944#3847944
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3847944
-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
