[sqlite] Bindings problem

Hi I'm new to Sqlite and Python and have hit a snag. I have a function that receives a single parameter record that contains the contents for the column testdata The program fails with the message: Incorrect number of bindings supplied. The current statement uses 0, and there are 10

Re: [sqlite] Bindings problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alan Hyde wrote: def updateDb(record): c.execute('INSERT INTO ardrecords (testdata) VALUES (?)', (record)) Short answer: You should not be quoting the ? and are missing a comma after record. Long answer: Quoting the question mark inserts a

[sqlite] Bindings problem

Thank you Roger - appreciated. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users