Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 90295 invoked from network); 7 Sep 2007 17:58:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Sep 2007 17:58:54 -0000 Received: (qmail 22725 invoked by uid 500); 7 Sep 2007 17:58:47 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 22710 invoked by uid 500); 7 Sep 2007 17:58:47 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 22699 invoked by uid 99); 7 Sep 2007 17:58:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Sep 2007 10:58:47 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of helgew@grajagan.org designates 66.159.194.18 as permitted sender) Received: from [66.159.194.18] (HELO mail.grajagan.org) (66.159.194.18) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Sep 2007 17:58:43 +0000 Received: from [192.168.0.120] (activx.com [12.184.141.98]) (authenticated bits=0) by mail.grajagan.org (8.14.1/8.14.1) with ESMTP id l87HwL5f024038 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO) for ; Fri, 7 Sep 2007 10:58:21 -0700 Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: <0CE15DD3-C317-4A90-8747-265991AFFF68@grajagan.org> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: Apache Torque Users List From: Helge Weissig Subject: Criteria.addAsColumn and Criteria.add{Ascending,Descending}OrderByColumn not compatible? Date: Fri, 7 Sep 2007 10:58:15 -0700 X-Mailer: Apple Mail (2.752.2) X-Greylist: Sender succeeded SMTP AUTH authentication, not delayed by milter-greylist-2.0 (mail.grajagan.org [66.159.194.80]); Fri, 07 Sep 2007 10:58:21 -0700 (PDT) X-Virus-Scanned: ClamAV 0.91.1/4178/Fri Sep 7 01:54:58 2007 on bluejay.grajagan.org X-Virus-Status: Clean X-Virus-Checked: Checked by ClamAV on apache.org Hi there, I found a message in the archives dated sometime in 2003 that described the exact same problem I am having: if you add an alias for a column with Criteria.addAsColumn(), you cannot use it as a orderByColumn using Criteria.addAscendingOrderByColumn() or Criteria.addDescendingOrderByColumn() because somewhere a table_name.COLUMN_NAME format is enforced and a TorqueException is thrown. FWIW, a fix/patch was also reported: http://mail- archives.apache.org/mod_mbox/db-torque-user/200310.mbox/% 3cB0EC737D3663D411868C00D0B77A8BC49DC254@nt_exchange%3e Are there any plans of addressing this? If not, what is the process of providing patches? Last not least, did anyone come up with a different work-around? FWIW, we are using the 3.2 RC1 tagged code from the svn repository. thanks, h. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org