Return-Path: Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org Received: (qmail 68532 invoked from network); 4 Sep 2006 09:11:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Sep 2006 09:11:00 -0000 Received: (qmail 35952 invoked by uid 500); 4 Sep 2006 09:10:57 -0000 Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org Received: (qmail 35884 invoked by uid 500); 4 Sep 2006 09:10:57 -0000 Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list dev@jackrabbit.apache.org Received: (qmail 35868 invoked by uid 500); 4 Sep 2006 09:10:57 -0000 Delivered-To: apmail-incubator-jackrabbit-dev@incubator.apache.org Received: (qmail 35861 invoked by uid 99); 4 Sep 2006 09:10:57 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Sep 2006 02:10:57 -0700 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of david.nuescheler@gmail.com designates 66.249.82.228 as permitted sender) Received: from [66.249.82.228] (HELO wx-out-0506.google.com) (66.249.82.228) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Sep 2006 02:10:56 -0700 Received: by wx-out-0506.google.com with SMTP id s13so1815179wxc for ; Mon, 04 Sep 2006 02:10:35 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZivPqVLILHPIGkANtp4luiVk9Eul6VheV6c3NYSz2J6nrtLY+ZHUPnOW/3+awP1el7C2pJdHScCV7AEv2L9yinZb8O6Q7chTwxLUFqRE4j5iFGEuuFoQrzjNp8+OlHDm662Tu4V4oTHW/3efXMCT2hV0O4L2ekDozAVLyIHc5Uw= Received: by 10.90.113.20 with SMTP id l20mr1057932agc; Mon, 04 Sep 2006 02:10:35 -0700 (PDT) Received: by 10.90.67.10 with HTTP; Mon, 4 Sep 2006 02:10:35 -0700 (PDT) Message-ID: Date: Mon, 4 Sep 2006 11:10:35 +0200 From: "David Nuescheler" Reply-To: david.nuescheler@day.com To: dev@jackrabbit.apache.org Subject: Re: Searching binary data Cc: jackrabbit-dev@incubator.apache.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Roy, first of all I think this is rather a post for the user list than the dev list of Jackrabbit. On 9/2/06, Roy Russo wrote: > Running in to a problem when searching jcr:data types... > > "select * from portalcms:content where jcr:data like '%JBoss%'"; I assume that in your example you want to issue a fulltext search looking for "JBoss", correct? So your query should look like this: select * from nt:resource where contains(*,'JBoss') See page 296: 8.5.4.5 CONTAINS of the JCR v1.0 spec regards, david