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...
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 12.42 > A: 'Apache Torque Users List' > Oggetto: AW: Problems with Criteria and ORDER BY > > > > > > -----Urspr�ngliche Nachricht----- > > Von: Maurice Wijtten [mailto:[EMAIL PROTECTED] > > Gesendet: Donnerstag, 23. Oktober 2003 12:43 > > An: Apache Torque Users List > > Betreff: Re: Problems with Criteria and ORDER BY > > > > > > Why don't just use criteria.addSelectColumn("count(" + > > PeerName.fieldconstant + ")"); > > The field constants usually include the tablename. (usually > you'll be > > able to find a column as a substitute for the * sign). > > > > Maurice Wijtten > > The difficult part is the "order by" part. I want to order > the result set according to the "count(whatever)" column. > > Regards > > Michael Burschik > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
