I had the exact same problem, and someone on the list solved it. You
will need to patch BasePeer and rebuild Torque.
As in my 3.0.2 dist:
(line aprox 1230)
if (aliases.containsKey(alias)) {
orderByClause.add(orderByColumn);
}
else {
if (orderByColumn.indexOf('.') == -1) {
throwMalformedColumnNameException(
.
.
.
}
e-mail and I can send you the patched jar (remind it is v 3.0.2)
--- Michael Burschik <[EMAIL PROTECTED]> escribi�:
> 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]
>
------------
Internet GRATIS es Yahoo! Conexi�n
4004-1010 desde Buenos Aires. Usuario: yahoo; contrase�a: yahoo
M�s ciudades: http://conexion.yahoo.com.ar
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
