Hello, I just went through this same process a few days ago. Here's how I got it to work. You need to use IN LIST and then you put the values in directly (ie without using bind)
SELECT a Organization a WHERE a.id IN LIST( 84918, 84919, 84920) -----Original Message----- From: Stephenson Tim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 9:19 PM To: [EMAIL PROTECTED] Subject: [castor-dev] SQL IN supported in OQL? a bit of a newbie question i am afraid: how can i do an IN expression? the sql i have in mind is: select * from ia_restriction where loc_type in ('OPTION1', 'OPTION2') TIA, tim ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
