Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (herse.apache.org: domain of
 the.mindstorm.mailinglist@gmail.com designates 64.233.162.227 as permitted
 sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=JcZWg0kd7CgfLlnehACOsSSiMn1Ox9cYkgzHFAI9zdMC9e9BkB5JAz3u4qwhke1COWi5n8Awza4RLQplhsS4zFiWkWstUPyJGZ4TYo7AqceFkt5br8SyGhbWV/MOCc2AJfTs38dhWlhIkthHNE8ASU39w/3lYUnG8xNH9yRBH/c=
Message-ID: <c6f400460706181626g79e2d191id16fdd96d2bffa49@mail.gmail.com>
Date: Tue, 19 Jun 2007 02:26:21 +0300
From: "=?UTF-8?Q?Alexandru_Popescu_=E2=98=80?="
 <the.mindstorm.mailinglist@gmail.com>
To: users@jackrabbit.apache.org
Subject: Re: How to escape double quote in SQL term?
In-Reply-To: <4676AA0B.9070602@gmx.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <11025910.post@talk.nabble.com>
	 <510143ac0706090135v2a759351kfb44e4028d04bd1f@mail.gmail.com>
	 <11056250.post@talk.nabble.com> <4676AA0B.9070602@gmx.net>

On 6/18/07, Marcel Reutegger <marcel.reutegger@gmx.net> wrote:
> gsoap wrote:
> > This does not work in case if we search only " see following query:
>
> you cannot search for the double quote character using the contains function.
> the default tokenizer recognizes the character as noise and ignores it.
>
> > SELECT * FROM nt:base WHERE CONTAINS(., '""""')
> >
> > In the above query we have a single term and we are searching only " which
> > you say should be replaced by "" but it results in parser exception.
>
> please note that you don't have to escape the the double quote in a SQL string
> literal. you only have to escape the single quote:
>
> e.g. if you have the following String literal in your java code:
>
> String s = "this string contains ' a single quote";
>
> when you use this string in a SQL contains function you must encode it like this:
>
> ... where contains(., 'this string contains '' a single quote')
>
> but here's the important part: double quotes in the string literal of a contains
> function have a special semantic. they mark phrases. e.g. you can search for
> nodes that contain the words apache and jackrabbit as consecutive terms:
>
> ... where contains(., '"apache jackrabbit"')
>
> if you have just one double quote or nothing between two double quotes the
> parser will complain that the contains statement is malformed.
>
> regards
>   marcel
>

Hi Marcel!

Thanks for the insights. I am wondering where are these bits documented?

tia,

./alex
--
.w( the_mindstorm )p.