[sqlite] Bindings problem

2008-04-29 Thread Alan Hyde
Thank you Roger - appreciated.


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


[sqlite] Bindings problem

2008-04-29 Thread Alan Hyde
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 supplied

There are 10 chars in the string variable that gets passed...it looks  
like the code sees each char in the string as a separate binding?

The source is as follows:

def updateDb(record):
c.execute('INSERT INTO ardrecords (testdata) VALUES ("?")', (record))



Thanks for the help.

Alan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users