Hi; I have this code: sql = "insert into %s (%s) values ('%%s');" % (personalDataTable, string.join(cols[1:], ', ')) # cursor.execute(sql, string.join(vals[1:], "', '")) cursor.execute('insert into %s (%s) values ("%s");' % (personalDataTable, string.join(cols[1:], ', '), string.join(vals[1:], '", "')))
Now, if I uncomment the 2nd line and comment the third, the command fails because, apparently, that "');" at the tail end of sql (1st line) gets chopped off. Why?? TIA, beno (Note to self: enterPeople3.py)
-- http://mail.python.org/mailman/listinfo/python-list