jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gsoap <gsoap...@yahoo.com>
Subject Re: How to escape double quote in SQL term?
Date Mon, 11 Jun 2007 07:41:21 GMT

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.


Mime
View raw message