Re: Error on insert statement...

2002-06-22 Thread Paul DuBois
At 17:30 -0400 6/21/02, Michael Jessop wrote: >Can someone tell me what this means? I mean, I guess I *know* what it >means, but why? Placeholders for Python scripts using MySQLdb should be %s, not ?. Convert your ? characters to %s and see what happens. > >The insert statement into a mysql dat

Error on insert statement...

2002-06-21 Thread Michael Jessop
Can someone tell me what this means? I mean, I guess I *know* what it means, but why? The insert statement into a mysql database is... 'insert into works values(?, ?, ?, ?, ? ,?)' The invocation of the dynamic sql is... status = cur_mysql.execute(sql, (wrk_inst, ZERO, trs_inst, a