-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 question mark and is
not a binding. Also SQL uses single quotes as standard for strings with
double quotes resulting in implementation specific behaviour. (record)
is the same as record - to make it a sequence of the string you need to
use (record,). The final result should be:
def updateDb(record):
c.execute('INSERT INTO ardrecords (testdata) VALUES (?)', (record,))
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFIF+mTmOOfHg372QQRAvyAAJoCflNdTK8SqaitpgDEVxxQrlKVFQCfdcyu
QTpI30wDGQKgyjHBhiTkiuA=
=ETTQ
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users