On 11/16/08, Ben Marchbanks <[EMAIL PROTECTED]> wrote:
> Abridged sample of the insert statement that produces an error when
> trying to insert escaped text.....
>
>
> INSERT INTO pageWords (word) VALUES (" \"nitch\" ");
SQL text strings are delimited by single quotes. If your really want
to insert "nitch" (including the double quotes), try ... VALUES
('"nitch"');
Alternatively, check out the ESCAPE clause in SQLite docs.
>
> SQLSTATE[HY000]: General error: 1 near "nitch": syntax error'
>
>
> Using
>
> PHP Version 5.2.4
> PDO SQLite - version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2
> 2007/03/23 14:30:00 wez Exp $
> SQLite 3.4.2
>
> --
> *Ben Marchbanks*
>
> www.magazooms.com <http://www.magazooms.com/>
> Signature
> Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> Phone: (864) 284.9918
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
