RE: Problems with Criteria and ORDER BY

[Amit Rana]

Use criteria.addSelectColumn("count(*)"); to add count(*)
Use tablePeer. doSelectVillageRecords(criteria) to retrieve records

then you can fetch the value from the list.

HTH

> -----Original Message-----
> From: Michael Burschik [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 6:31 PM
> To: [EMAIL PROTECTED]
> Subject: Problems with Criteria and ORDER BY
> 
> The BasePeer.createQuery method checks whether the order by column
contains
> a "." and throws an exception if it does not. This is not a very good
idea.
> First of all, it does not catch non-existent column names that happen
to
> include a ".". And secondly, it does not allow for the perfectly legal
use
> of a column alias in the order by statement, e.g. "select somecolumn,
> count(*) as count from mytable order by count". Is there another way
to get
> this, apart from the obvious solution of building the statement
manually?
> 
> 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]