Use de Criteria.CUSTOM to make the query. It will work,
Michael Burschik wrote:
-----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]
--
------------------------
Felipe Ramos
Tissat SA
C/ Orense 34-9�
28020 Madrid
Tel: (+34) 91 4175913 Fax: (+34) 91 4172914
Mail: [EMAIL PROTECTED]
------------------------
