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 <[EMAIL PROTECTED]> 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.
