Thanks a lot. The issue has been fixed with:
INSERT INTO TEST_TABLE(CONTENTS) VALUES ("Hello. World!");I was thrown by the error message that seemed to be complaining about the periods when I was actually missing the VALUES(...) clause. Appreciate the quick response ... deech On Sun, Dec 14, 2008 at 11:21 PM, John Stanton <[email protected]> wrote: > Note that literal delimiters in SQL are single quotes, e.g. 'This is an > SQL literal'. > > It is good practice with Sqlite to use bound variables. You avoid > possible SQL injection attacks and limit sensitivity to data content. > > aditya siram wrote: > > Hi all, > > I'm having trouble adding data with period characters in it. I tries to > > escape the period with a `'` but that didn' t seem to work. Here is an > > example interaction: > > > > sqlite> create table test_table ("Contents" varchar); > > sqlite> insert into test_table "hello . world"; > > SQL error: near ""hello . world"": syntax error > > sqlite> insert into test_table "hello '. world"; > > SQL error: near ""hello '. world"": syntax error > > > > Thanks ... > > deech > > _______________________________________________ > > 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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
