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 AW: Problems with Criteria and ORDER BY
Date Thu, 23 Oct 2003 12:34:50 GMT
> -----Urspr√ľngliche Nachricht-----
> Von: Giulio Vezzelli [mailto:giulio.vezzelli@infolog.it]
> Gesendet: Donnerstag, 23. Oktober 2003 14:22
> An: Apache Torque Users List
> Betreff: R: Problems with Criteria and ORDER BY
> Sorry, I missed the "dot exception" part of your first mail.
> Try this thing, may screw up everything but...
> Name the column as COUNT(*) AS 'TABLENAME.COUNTCOLUMN'
> Using the ', it will force the dot in the name of the column...
> Then the orderby would be 'TABLENAME.COUNTCOLUMN'
> It depends on which kind of check does Torque do on the 
> column names...

Thanks for your suggestion. I thought of that too, but apparently COUNT(*)
AS 'TABLENAME.COUNTCOLUMN' is not valid SQL. At least, Oracle does not
accept it.


Michael Burschik

View raw message