|
Have you tried passing the list as a Collection object?
I've never actually done it. All the examples I've seen have the list
of the IN clause hardcoded in the finder's QL.
Sorry,
Joe
>>> "Hunter Ren" <[EMAIL PROTECTED]> 06/10/02 02:16PM >>> I am using JBOSS, and I have a query like this: query="user_id in (select vum.user_id from vendor_user_map vum, group_map gm where gm.user_id = vum.user_id and gm.group_id= {0} and vum.vendor_id in {1})" where parameter 0 is an integer, and parameter 1 is an integer list. My problem is how to define the second parameter? The current query work if I set parameter 1 to an integer (like "163", or "(163)"). But when I set it to a list (like "163, 164", or "(163, 164)"), it doesn't work and says "invalid number". How could I pass a list to the query? Could anyone help me out? Thank you very much. Hunter Ren _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas - http://devcon.sprintpcs.com/adp/index.cfm?source=osdntextlink _______________________________________________ Xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user |
