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... Giulio Vezzelli Infolog S.r.l. Via Alfieri, 28 Modena - 41100 Telefono : +39-059-822446 Sito web : http://www.infolog.it E-mail : [EMAIL PROTECTED] > -----Messaggio originale----- > Da: Michael Burschik [mailto:[EMAIL PROTECTED] > Inviato: gioved� 23 ottobre 2003 14.05 > A: 'Apache Torque Users List' > Oggetto: AW: Problems with Criteria and ORDER BY > > > > -----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]
