Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 73491 invoked from network); 6 Mar 2008 02:54:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 6 Mar 2008 02:54:36 -0000 Received: (qmail 23013 invoked by uid 500); 6 Mar 2008 02:54:29 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 22947 invoked by uid 500); 6 Mar 2008 02:54:29 -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 22909 invoked by uid 99); 6 Mar 2008 02:54:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Mar 2008 18:54:29 -0800 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: local policy) Received: from [64.81.61.238] (HELO cantara.com) (64.81.61.238) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Mar 2008 02:53:54 +0000 Received: from [127.0.0.1] (dsl081-061-238.sfo1.dsl.speakeasy.net [64.81.61.238]) (authenticated bits=0) by cantara.com (8.13.1/8.13.1) with ESMTP id m262rv9M019420 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 5 Mar 2008 18:53:57 -0800 Subject: using prepared statements for "in" From: Raul Acevedo To: torque-user@db.apache.org Content-Type: text/plain Date: Wed, 05 Mar 2008 18:53:59 -0800 Message-Id: <1204772039.31999.6.camel@raul690.n-gage.com> Mime-Version: 1.0 X-Mailer: Evolution 2.12.3 (2.12.3-1.fc8) Content-Transfer-Encoding: 7bit X-Spam-Score: -1.4 ALL_TRUSTED,AWL,BAYES_00,EMPTY_MESSAGE [] X-Spam-Sender: Sender [] X-Scanned-By: MIMEDefang 2.48 on 64.81.61.238 X-Virus-Checked: Checked by ClamAV on apache.org When you use Criteria.addIn, Torque does not generate a prepared statement. (Or at least it doesn't use bind variables for the "in" part, even if it does for other parts of the query.) Is there a way to get Torque to use bind variables for this? Without having to convert the query into a bunch of "or"s? Raul --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org