hi douglas, i just checked in a fix on the OQL-grammar to allow order by without 'asc'. you can now use :
'order by xx' (will use asc !) 'order by xx asc' 'order by xx desc' > It worked!!! And thank you, thank you, thank you do you need the number of my swiss bank account ?? hth jakob ----- Original Message ----- From: "Douglas Montanus" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 8:08 PM Subject: RE: Order By ?????????? > It worked!!! And thank you, thank you, thank you > > -----Original Message----- > From: Jakob Braeuchi [mailto:jbraeuchi@;gmx.ch] > Sent: Wednesday, October 30, 2002 1:31 PM > To: OJB Users List > Subject: Re: Order By ?????????? > > hi douglas, > > you have to add either 'asc' or 'desc' to make it work. > i do not know wether really OQL requires asc or desc ??? > > jakob > > ----- Original Message ----- > From: "Douglas Montanus" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, October 30, 2002 5:38 PM > Subject: Order By ?????????? > > > > I have a question the ODMG implementation of OQL. I seem to be > having > > problems with the ORDER BY clause in my query statement. It appears > to > > be ignored. I have examined the DEBUG log for > > > org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.LogLevel=D > > EBUG > > and my order by clause dose not appear. Help me. In need things > sorted > > badly. Here is a code sniplet: > > > > tx.begin(); > > > > // 2. get an OQLQuery object from the ODMG facade > > OQLQuery query = odmg.newOQLQuery() > > > > // 3. set the OQL select statement > > > > query.create("select allEmployee from "+ > > Employee.class.getName() + " order by lastname, firstname") ; > > > > // 4. perform the query and store the result in a persistent > > Collection > > col = (DList) query.execute(); > > tx.commit(); > > > > > > Douglas > > > > > > -- > To unsubscribe, e-mail: > <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: > <mailto:ojb-user-help@;jakarta.apache.org> > > > -- > To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
