db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: orderBy clause failing to accept an alias
Date Mon, 10 Mar 2008 19:00:19 GMT
Hmm, this looks to be a bit of a book work error.  I traced this back
to the Torque-89 Jira issue.  This is still open because the 
reporting user never replied that the patch worked.  And no test
case to verify it was created.

However, in looking over the changes, it looks like one part of 
the requested change was not made.  In the SQLBuilder processOrderBy
method, there is a call to removeSQLFunction(...).  This will return
the exception you are seeing.

The missing part is a try / catch around this call with the catch
part using the original column name.  See:


> -----Original Message-----
> From: Subadhra Jagannathan [mailto:subadhra.jagannathan@gmail.com]
> Sent: Monday, March 10, 2008 2:27 PM
> To: Apache Torque Users List
> Subject: orderBy clause failing to accept an alias
> Hello, All,
> I am new to torque. In the new torque release, the change log says --
> "OrderBy now accepts column names without a dot. No additional
> processing is
> made for these".
> But I am trying to use an alias with the orderBy clause and it fails
> with
> "removeSQLFunction() : Column name mz ASC does not contain a . or a *"
> message. How do I circumvent this?
> Thanks a lot.
> Subadhra
DukeCE Privacy Statement:
Please be advised that this e-mail and any files transmitted with
it are confidential communication or may otherwise be privileged or
confidential and are intended solely for the individual or entity
to whom they are addressed. If you are not the intended recipient
you may not rely on the contents of this email or any attachments,
and we ask that you please not read, copy or retransmit this
communication, but reply to the sender and destroy the email, its
contents, and all copies thereof immediately. Any unauthorized
dissemination, distribution or copying of this communication is
strictly prohibited.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message