[EMAIL PROTECTED] wrote: > 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 >
Thanks guys. I'll try this. I thought the ? stood for the whole tuple. -- http://mail.python.org/mailman/listinfo/python-list