hi roger,
you're right that's too negative :( i hope i got it right this time.
jakob
Janssen, Roger schrieb:
hi,
using current cvs head, using the NOT_IN operator on criteria result in an query:
SELECT ... FROM TABLE1 A0 WHERE NOT (A0.ATTR NOT IN (?,?))
[ the sql was captures with spy ]
as we see, a the NOT IN claise is negated, NOT is put in front of it, my guess is that two implementations have been mixed, one that results in a query like
SELECT ... FROM TABLE1 A0 WHERE A0.ATTR NOT IN (?,?)
and one that results in a query like
SELECT ... FROM TABLE1 A0 WHERE NOT (A0.ATTR IN (?,?))
hope this helps the guy who needs to fix this.
Roger Janssen
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
