No, that did not work. ORDER BY 1 throws an exception: java.lang.Exception: Only identifiers, path expressions, and the keywords ASC and DESC are allowed in the ORDER BY clause. Any other ideas? Brad ----- Original Message ----- From: "SS Zabiullah-a13771" <> To: <[EMAIL PROTECTED]> Sent: Monday, August 27, 2001 6:56 PM Subject: Re: [castor-dev] Problem with ORDER BY > Did you try giving numbers , ORDER BY 1 (first field of your result). Though equally same. > Zabi. > > -----Original Message----- > From: Brad Matlack [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 28 August 2001 5:58 > To: [EMAIL PROTECTED] > Subject: [castor-dev] Problem with ORDER BY > > > 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
