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]
-------------------------------------------------
