> -----Urspr�ngliche Nachricht----- > Von: Giulio Vezzelli [mailto:[EMAIL PROTECTED] > 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. Regards Michael Burschik
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
