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