You are viewing a plain text version of this content. The canonical link for it is here.

Posted to torque-user@db.apache.org by Ryan Bales <ry...@soundstrue.com> on 2008/07/03 08:52:51 UTC

Order By with Alias

Hello

I have the following:

...
criteria.addAsColumn("relevance", matchClause);

and I would like to order by "relevance" --which obviously is  
undefined in my Torque classes.

so I tried:

criteria.addDescendingOrderByColumn("relevance");

but get the following error:

"removeSQLFunction() : Column name relevance DESC does not contain a .  
or a *"

Does anyone know of a way around this? I read some mention that the  
problem was resolved in RC3, but I am still getting the error. Any  
help would be great.