Hmmm - thanks for straightening me out guys - somehow I thought that SQLite used double quotes....
*Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918 John Stanton wrote: > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
