John Salerno wrote: > 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
I believe you're missing the parens around your VALUES to insert. Also, you need 1 placeholder per argument inserted, not just one for the entire argument list. Try: self.connection.execute("INSERT INTO Personal (firstName, lastName) VALUES (?, ?)", t) HTH -- http://mail.python.org/mailman/listinfo/python-list