Re: [sqlite] SQL question, probably stuipid but ...

[Lloyd]

To escape "'" use cosecutive "'" , i.e "''"

On Wed, 18 Feb 2009 10:32:28 +0530, J. R. Westmoreland  wrote:

> I can't remember how to escape a "'" in a string.
>
> My statement looks something like:
>
> "insert . values ('DAY'S AVE' .);
>
>
> It's been a long day.
>
> Thanks in advance.
>
>
> J. R.
>
>
> 
>
> J. R. Westmoreland
>
> E-mail: j...@jrw.org
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



__
Scanned and protected by Email scanner
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL question, probably stuipid but ...

[J. R. Westmoreland]

I can't remember how to escape a "'" in a string.

My statement looks something like:

"insert . values ('DAY'S AVE' .);

 

It's been a long day.

Thanks in advance.

 

J. R.

 



J. R. Westmoreland

E-mail: j...@jrw.org

 

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