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

Reply via email to