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]
