I'm having a problem getting ORDER BY to work.
I've downloaded and compiled the nightly build.
// here's the code segment
db.begin();
oql = db.getOQLQuery( "SELECT m FROM
com.workzen.app.velocityCastor.om.Message m
WHERE isParent = $1 ORDER BY m.subject ASC" );
oql.bind((short)1);
results = oql.execute();
...
db.commit();
I've tried different combinations of the orderby_clause: subject, m.subject,
Message.subject, but none work.
What am I missing???
Thanks
Brad Matlack
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev