sqlite error?

John Salerno johnjsal at NOSPAMgmail.com
Mon Nov 6 16:11:01 EST 2006


Am I using the ? placeholder wrong in this example?


t = ('hi', 'bye')

self.connection.execute("INSERT INTO Personal (firstName, lastName) 
VALUES ?", t)



Traceback (most recent call last):
   File "C:\Python25\myscripts\labdb\dbapp.py", line 93, in OnSaveRecord
     self.save_to_database(textfield_values)
   File "C:\Python25\myscripts\labdb\dbapp.py", line 97, in save_to_database
     self.connection.execute("INSERT INTO Personal (firstName, lastName) 
VALUES ?", t)
sqlite3.OperationalError: near "?": syntax error



More information about the Python-list mailing list