db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Burschik" <Bursc...@lotto-berlin.de>
Subject Problems with Criteria and ORDER BY
Date Thu, 23 Oct 2003 09:30:34 GMT
The BasePeer.createQuery method checks whether the order by column contains
a "." and throws an exception if it does not. This is not a very good idea.
First of all, it does not catch non-existent column names that happen to
include a ".". And secondly, it does not allow for the perfectly legal use
of a column alias in the order by statement, e.g. "select somecolumn,
count(*) as count from mytable order by count". Is there another way to get
this, apart from the obvious solution of building the statement manually?

Regards

Michael Burschik


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message