Does the query actually have a FROM clause (i.e., SELECT a FROM Asset a WHERE ...)?
Is Asset.getSiteId().getId() really a valid sequence of calls on your objects? ******************************************** Steve Ebersole IT Integration Engineer Vignette Corporation 512.741.4195 Visit http://www.vignette.com ******************************************** -----Original Message----- From: Martin, Margaret [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 7:15 PM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] OQL - Projection question - PLEASE HELP!! I am trying to do something similar: SELECT a Asset a WHERE a.siteId.id IN LIST( 1,2366) But I'm getting this exception: org.exolab.castor.jdo.oql.OQLSyntaxException: An incorrect token type was found near com (2, need 5 at org.exolab.castor.jdo.oql.Parser.match(Parser.java:144) at org.exolab.castor.jdo.oql.Parser.fromClause(Parser.java:214) at org.exolab.castor.jdo.oql.Parser.getParseTree(Parser.java:92) at org.exolab.castor.jdo.engine.OQLQueryImpl.create(OQLQueryImpl.java:268) at org.exolab.castor.jdo.engine.DatabaseImpl.getOQLQuery(DatabaseImpl.java:439) Can anyone help me out here? Thanks a bunch! Margaret Martin -----Original Message----- From: Bruce Snyder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 12:39 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] OQL - Projection question - PLEASE HELP!! This one time, at band camp, Matthew Clark said: MC>How do I select a sub-set of data (similar to SQL LIMIT 0,20 statement) Matthew, Please see http://www.mail-archive.com/[email protected]/msg02098.html Bruce -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&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 ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
