Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 4110 invoked from network); 16 Oct 2006 16:02:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Oct 2006 16:02:44 -0000 Received: (qmail 80430 invoked by uid 500); 16 Oct 2006 16:02:43 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 80421 invoked by uid 500); 16 Oct 2006 16:02:43 -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 80410 invoked by uid 99); 16 Oct 2006 16:02:43 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Oct 2006 09:02:43 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [217.24.207.26] (HELO mail.seitenbau.net) (217.24.207.26) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Oct 2006 09:02:41 -0700 Received: from [192.168.15.18] (helo=www.seitenbau.net) by router.seitenbau.net with esmtp (Exim 4.43) id 1GZUuy-0006y3-Cv for torque-user@db.apache.org; Mon, 16 Oct 2006 18:02:20 +0200 In-Reply-To: Subject: RE: Problems to set up a subquery To: "Apache Torque Users List" X-Mailer: Lotus Notes Release 7.0.1 January 17, 2006 Message-ID: From: Thomas Fischer Date: Mon, 16 Oct 2006 18:02:21 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 7.0.1|January 17, 2006) at 16.10.2006 06:02:20 PM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, Subqueries are implemented and documented in the svn version(3.2.1-dev), but not in Torque 3.2.0. Either build Torque from svn or, if you want to use Torque 3.2.0. you can code the subquery as custom criteria (see http://db.apache.org/torque/releases/torque-3.2 /runtime/reference/read-from-db.html#Using_the_CUSTOM_modifier_to_use_custom_SQL) (you can also build the subquery via another Criteria and its toString()-method if you do not want to hand-code it). Thomas "Pfiester, Jan" schrieb am 16.10.2006 17:40:05: > Hi everyone, > > I ran into problems to setup the following query using criteria: > > SELECT DISTINCT * FROM kundenadresse > WHERE kundenadress_id NOT IN( > SELECT kundenadress_id FROM adressenreferenz > ); > > Could someone please give me some help to come up with a proper solution? > Hints for further reading on this topic would also be very much appreciated! > > Many thanks in advance, > Jan > > --------------------------------------------------------------------- > 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