Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Reply-To: <Burschik@lotto-berlin.de>
From: "Michael Burschik" <Burschik@lotto-berlin.de>
To: <torque-user@db.apache.org>
Subject: Problems with Criteria and ORDER BY
Date: Thu, 23 Oct 2003 11:30:34 +0200
Message-ID: <002401c39948$4fef6550$920115ac@EDV46>
MIME-Version: 1.0
Content-Type: text/plain; 	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Importance: Normal

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