Thanks - I did find a solution since I was not successful using
sqlite_escape_string.
I think that the SQLite implementation in PHP via PDO is the culprit.
I wound up using double escape - str_replace("\"","\"\"",$value);
*Ben Marchbanks*
www.magazooms.com <http://www.magazooms.com/>
Signature
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Phone: (864) 284.9918
P Kishor wrote:
> 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
>>
>>
>
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
