db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: orderBy clause failing to accept an alias
Date Thu, 13 Mar 2008 10:28:30 GMT

For simple queries as yours this should work, regardless of the patch.

Yan you please describe what you want to do and how you are trying to do it
?

    Thomas

"Greg Monroe" <Greg.Monroe@DukeCE.com> schrieb am 10.03.2008 20:00:19:

> 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:
>
> http://issues.apache.org/jira/browse/TORQUE-89?focusedCommentId=12488935
> #action_12488935
>
> > -----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
>


---------------------------------------------------------------------
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