jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gsoap <gsoap...@yahoo.com>
Subject An issue in escaping double quote in SQL
Date Mon, 11 Jun 2007 11:01:15 GMT


If we escape double quote in SQL by replacing it by two double quotes like

SELECT * FROM nt:base WHERE CONTAINS(., '"This line have "" quote"')

then 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
if we replace by "" it results in parser exception. 

Kindly suggest something. 


View this message in context: http://www.nabble.com/An-issue-in-escaping-double-quote-in-SQL-tf3900905.html#a11058604
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

View raw message