Now I remember why I wasn't using single quotes in SQLite statements - because escaped single quoted values like
'Billy\'s bike' cause it to fail. Again I think its related to PHP-PDO SQLite implementation..... *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918 Ben Marchbanks wrote: > 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 >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
