Does the current version of Castor support "IN" with subqueries? For example, is the following OQL query valid?
SELECT x.id FROM Employee x WHERE id IN (SELECT y.id FROM Employee y) (Yes, I know this is a pointless query - I just wanted to present a simplistic example.) Looking at the OQL definition posted on castor.exolab.org, "IN" seems to be supported, but I get the following exception when I attempt to assemble an "IN" clause with subqueries like the one above: An inapropriate token (1) was encountered in an expression. org.exolab.castor.jdo.oql.OQLSyntaxException: An inapropriate token (1) was encountered in an expression. Note, however, that a query like the following works just fine: SELECT x.id FROM Employee x WHERE id IN list(1, 2) Anyone have some insight into this? __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
