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