Sabot <[EMAIL PROTECTED]> wrote:
// so query looks like:
INSERT INTO version (date,active,category,entry) VALUES ('2007-05-31
18:50','x','NOTE','test 'test' test');
The problem is of course with the last field, 'test 'test' test' . It's
not valid SQL. If you want to put a single quote into a string literal,
you need to double it, as in 'here''s a ''quoted'' word' . In PHP, see
sqlite_escape_string: http://us.php.net/sqlite-escape-string
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
