jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jukka Zitting" <jukka.zitt...@gmail.com>
Subject Re: How to escape double quote in SQL term?
Date Sat, 09 Jun 2007 08:35:29 GMT
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

Mime
View raw message