This one time, at band camp, Aditya Akella said:
AA>I tried it but i'm getting an exception. Here is my SQL and the error
AA>message I get.
AA>
AA>SELECT p FROM com.PCPgo.prm.web.location.LocationICDJdo p where
AA>p.icdCodeJdo.icdId NOT IN LIST (SELECT l.icdId FROM
AA>com.PCPgo.prm.web.location.LocationICDJdo WHERE l.loLocationId = $1)
AA>
...
AA>Am I doing anything wrong in the query after NOT or the keyword NOT IN is
AA>not supported bye castor?
The exception is telling us that Castor doesn't support the NOT IN syntax.
Even if it did support that syntax, Castor doesn't support sub-selects
so it would have failed there.
On a side note, I'm working on a new OQL engine implementation using
ANTLR. This implementation makes adding functionality *far, far* easier
than in the current implementation. The implementation is complete but
it needs to be tested before I commit it to CVS. Once this is committed,
I can certainly add support for the NOT IN syntax.
Bruce
--
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
