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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
