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:05:13 GMT
> -----Urspr√ľngliche Nachricht-----
> Von: Giulio Vezzelli [mailto:giulio.vezzelli@infolog.it]
> Gesendet: Donnerstag, 23. Oktober 2003 12:48
> An: Apache Torque Users List
> Betreff: R: Problems with Criteria and ORDER BY
> I think you can add the count column to the select query as 
> Maurice suggested, but adding "AS COUNTCOLUMN" to the count 
> string, and then use the addAscendingOrderByColumn method 
> with "COUNTCOLUMN" as the parameter. Don't know if it will 
> really work, just a suggestion...

This is what I first tried, and it does not work. As I tried to explain in
my first mail, BasePeer.createQuery throws an exception because the name of
the column (COUNTCOLUMN in your example) does not contain a dot. But of
course I can not use TABLENAME.COUNTCOLUMN either, since the table does not
have a column with that name.


Michael Burschik

View raw message