There are a number of syntax errors. Line 1 - You have an / that should not be there. Line 6 - You cannot call a module, only a function in a module (not strictly true, but in the case of pysqlite2, it is) Line 12 - You are missing the closing quote on the SQL string Line 17 - You have not indented the line
As for your syntax error, you probably have crap on a line that you think is empty. Or your editor is not putting in line endings properly and you have all one long continuation line. The syntax error was detected at the opening bracket on line 6 but your actual error occurred long before this. You may need to use a better text editor, or one that you are more familiar with. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >[email protected]] On Behalf Of John R. Sowden >Sent: Sunday, 22 October, 2017 20:59 >To: [email protected] >Subject: [sqlite] very sqlite3 noobie error > >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 >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
