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 behaviour or did I do something wrong?
> Thanks for your help.
> Aladdin
> _
> Inédit ! Des Emoticônes Déjantées! Installez les dans votre Messenger ! 
> http://www.ilovemessenger.fr/Emoticones/EmoticonesDejantees.aspx
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 at 9:53 AM, Aladdin Lampé <[EMAIL PROTECTED]> 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 behaviour or did I do something wrong?
> Thanks for your help.
> Aladdin
> _
> Inédit ! Des Emoticônes Déjantées! Installez les dans votre Messenger !
> http://www.ilovemessenger.fr/Emoticones/EmoticonesDejantees.aspx
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users