That did work. Thanks! ----- Original Message ---- From: Ralf Joachim <[EMAIL PROTECTED]> To: [email protected] Sent: Sunday, March 26, 2006 1:24:30 PM Subject: Re: [castor-user] [JDO] NOT IN LIST oql?
Hi Jon, have you tried: SELECT o FROM foo o WHERE NOT (id IN LIST(1,2,3)) Regards Ralf Jon Wilmoth schrieb: > I know castor supports a "in list" OQL where clause (i.e. SELECT o FROM foo o > WHERE id IN LIST(1,2,3)). How does one do an exclusive query? The following > OQL: > > SELECT o FROM foo o WHERE id NOT IN LIST(1,2,3) > > produces the following error: > > An incorrect token type was found near NOT (found KEYWORD_NOT, but > expected END_OF_QUERY) > > Thanks, > Jon > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] ------------------------------------------------- ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
