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 10:42:21 GMT


> -----Urspr√ľngliche Nachricht-----
> Von: Maurice Wijtten [mailto:mwi@lucka.nl]
> 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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message