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 lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <11056250.post@talk.nabble.com>
Date: Mon, 11 Jun 2007 00:41:21 -0700 (PDT)
From: gsoap <gsoap123@yahoo.com>
To: users@jackrabbit.apache.org
Subject: Re: How to escape double quote in SQL term?
In-Reply-To: <510143ac0706090135v2a759351kfb44e4028d04bd1f@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
References: <11025910.post@talk.nabble.com>
 <510143ac0706090135v2a759351kfb44e4028d04bd1f@mail.gmail.com>


Hi,

This does not work in case if we search only " see following query:

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.

Kindly suggest something.

Thanks.


Jukka Zitting wrote:
> 
> Hi,
> 
> On 6/8/07, gsoap <gsoap123@yahoo.com> wrote:
>> How can I escape double quote in my following query, following attempt
>> gives
>> error?
>>
>> SELECT * FROM nt:base WHERE CONTAINS(., '"This term contains \" double
>> quote."')
> 
> You can use "" for that. Like this:
> 
> SELECT * FROM nt:base WHERE CONTAINS(., '"This term contains "" double
> quote."')
> 
> BR,
> 
> Jukka Zitting
> 
> 

-- 
View this message in context: http://www.nabble.com/How-to-escape-double-quote-in-SQL-term--tf3889614.html#a11056250
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.