Re: [sqlite] Include a double quote inside a string-literal

2008-10-17 Thread John Stanton
SQL uses single quotes to delimit string literals. Aladdin Lampé wrote: > Hi! > Is it possible to include a \" (double quote) inside a string-literal? > I wanted to use a string-literal like "this is \"not working\"" but sqlite's > SQL parser doesn't seem to accept this. > Is it the intended beha

Re: [sqlite] Include a double quote inside a string-literal

2008-10-17 Thread Dennis Cote
Aladdin Lampé wrote: > Is it possible to include a \" (double quote) inside a string-literal? > I wanted to use a string-literal like "this is \"not working\"" but sqlite's > SQL parser doesn't seem to accept this. > Is it the intended behaviour or did I do something wrong? Yes, simply use SQL st

Re: [sqlite] Include a double quote inside a string-literal

2008-10-17 Thread Enrique Ramirez
Did you remember to put single quotes around your string? Your example shows double quotes: "this is \"not working\"" vs 'this is \"not working\"' // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com On Fri, Oct 17, 2008

[sqlite] Include a double quote inside a string-literal

2008-10-17 Thread Aladdin Lampé
Hi! Is it possible to include a \" (double quote) inside a string-literal? I wanted to use a string-literal like "this is \"not working\"" but sqlite's SQL parser doesn't seem to accept this. Is it the intended behaviour or did I do something wrong? Thanks for your help. Aladdin _