db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Felipe Ramos" <fra...@tissat.es>
Subject Re: AW: Problems with Criteria and ORDER BY
Date Thu, 23 Oct 2003 14:41:19 GMT
Use de Criteria.CUSTOM to make the query.
It will work,

Michael Burschik wrote:

>>-----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.
>
>Regards
>
>Michael Burschik
>
>  
>
>------------------------------------------------------------------------
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>

-- 
------------------------
Felipe Ramos
Tissat SA
C/ Orense 34-9ª
28020 Madrid
Tel: (+34) 91 4175913 
Fax: (+34) 91 4172914
Mail: framos@tissat.es
------------------------



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message