Since I am trying to learn sqlite3 (unlearning foxpro) I find that
python is the simpleist language, wfich allows me to focus on sqlite, I
amtrying the =guide just sent to the list.
I am getting a syntax error on line 5. below is the program copied by
hand from the guide:
----------------------
#/!python
# sqlite3_test, a test of python and sqlite
import sqlite3
connection = sqlite3(':memory:')
# create a table
connection.execute('create table events(ts, msg)')
# insert values
connection.execute('insert into events values(?,?),
[(1, 'foo'), (2,'bar'), (3,'baz') ] )
# print inserted rows
for row in connection.execute('select * from events'):
print(row)
-----------------------
can anyone tell me where i am missing something?
John
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users