Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 98555 invoked from network); 4 Mar 2010 16:26:50 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 4 Mar 2010 16:26:50 -0000 Received: (qmail 36559 invoked by uid 500); 4 Mar 2010 16:26:39 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 36528 invoked by uid 500); 4 Mar 2010 16:26:39 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 36519 invoked by uid 99); 4 Mar 2010 16:26:39 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Mar 2010 16:26:39 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of aklimets@day.com designates 207.126.148.89 as permitted sender) Received: from [207.126.148.89] (HELO eu3sys201aog103.obsmtp.com) (207.126.148.89) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 04 Mar 2010 16:26:29 +0000 Received: from source ([209.85.218.222]) by eu3sys201aob103.postini.com ([207.126.154.11]) with SMTP ID DSNKS4/fHwLccbR/ADb/TxbAUwEeobXiQBzi@postini.com; Thu, 04 Mar 2010 16:26:09 UTC Received: by bwz22 with SMTP id 22so229327bwz.28 for ; Thu, 04 Mar 2010 08:26:07 -0800 (PST) MIME-Version: 1.0 Received: by 10.102.235.8 with SMTP id i8mr453981muh.31.1267719966714; Thu, 04 Mar 2010 08:26:06 -0800 (PST) In-Reply-To: <1267716661570-1578233.post@n4.nabble.com> References: <1267716661570-1578233.post@n4.nabble.com> Date: Thu, 4 Mar 2010 17:26:06 +0100 Message-ID: Subject: Re: SQL2 - multiple where conditions From: Alexander Klimetschek To: users@jackrabbit.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org On Thu, Mar 4, 2010 at 16:31, Gadbury wrote: > SELECT * FROM Table WHERE id IN (0,2,3); > > Is there an equivelent in Jackrabbit 2.0 using the query language JCR_SQL2? > > I know the following works (but is there a better way?) : > > SELECT * FROM [my:table] WHERE [id]=0 OR[id]=2 OR [id]=3 "IN" is not supported. See http://www.day.com/specs/jcr/2.0/6_Query.html#Constraint Regards, Alex -- Alexander Klimetschek alexander.klimetschek@day.com