subject:"\[sqlite\] insert error"

Re: [sqlite] insert error

2011-12-20 Thread epankoke

<petite.abei...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, December 20, 2011 2:40:50 PM Subject: Re: [sqlite] insert error On Dec 20, 2011, at 8:34 PM, jim-on-linux wrote: > cursor.execute insert into default (rowname) v

Re: [sqlite] insert error

2011-12-20 Thread Petite Abeille

On Dec 20, 2011, at 8:34 PM, jim-on-linux wrote: > cursor.execute insert into default (rowname) values ( '1' ) ; 'default' is a keyword: http://www.sqlite.org/lang_keywords.html If you insist on that name, double quote it. ___ sqlite-users mailing

[sqlite] insert error

2011-12-20 Thread jim-on-linux

Can someone let me know why the following keeps giving invalid syntax err msg. con = sqlite3.connect(sqldb) cursor = con.cursor() cursor.execute insert into default (rowname) values ( '1' ) ; con.commit() con.close() I get invalid syntax pointing to the t in insert. jimonlinux