An SQL literal uses single quotes.
Ben Marchbanks wrote:
> Abridged sample of the insert statement that produces an error when
> trying to insert escaped text.....
>
>
> INSERT INTO pageWords (word) VALUES (" \"nitch\" ");
>
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
