Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 4370 invoked from network); 1 Feb 2007 20:15:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Feb 2007 20:15:03 -0000 Received: (qmail 81747 invoked by uid 500); 1 Feb 2007 20:15:08 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 81730 invoked by uid 500); 1 Feb 2007 20:15:08 -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 81721 invoked by uid 99); 1 Feb 2007 20:15:08 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Feb 2007 12:15:08 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates 72.21.53.35 as permitted sender) Received: from [72.21.53.35] (HELO talk.nabble.com) (72.21.53.35) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Feb 2007 12:14:58 -0800 Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1HCiKL-0004L3-MU for users@jackrabbit.apache.org; Thu, 01 Feb 2007 12:14:37 -0800 Message-ID: <8755525.post@talk.nabble.com> Date: Thu, 1 Feb 2007 12:14:37 -0800 (PST) From: gjoseph To: users@jackrabbit.apache.org Subject: Support for NOT LIKE in queries ? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: mwinmwin@gmail.com X-Virus-Checked: Checked by ClamAV on apache.org Hi list, I may be missing something obvious here, but even though the spec doesn't explicitely mention support for NOT LIKE statements, I was assuming it to be supported. However, doing a query like select * from foo:bar where jcr:path not like '/baz/' returns exactly the same results as select * from foo:bar where jcr:path like '/baz/' .. hence the "not" keyword being apparently completely ignored. Am I missing the obvious? Is this really not supported and/or specified? Is there an alternative way to get the desired results? (be in sql or xpath..) Thanks in advance ! greg -- View this message in context: http://www.nabble.com/Support-for-NOT-LIKE-in-queries---tf3157132.html#a8755525 Sent from the Jackrabbit - Users mailing list archive at Nabble.com.