I have this really strange problem. I hope someone can help: I am trying to update a database like so:
UPDATE `tablename` set fieldx='test' WHERE flfieldx = null and fieldy like '%certainvalue%' My Python code looks like this: fillsql = "UPDATE `tablename` set fieldx='test' WHERE flfieldx = null and fieldy like '%%%s%%' " % certainvalue print fillsql cursor.execute(fillsql) #also tried: #cursor.execute("UPDATE `tablename` set fieldx='test' WHERE flfieldx = null and fieldy like %s ", "%%%s%%" % certainvalue) But it doesn't work... But when i copy and past the SQL (printed by "print fillsql" line) and execute that in phpMyAdmin, it does work!!! Can anyone tell me what i am doing wrong?? Thanks in advance!! -- http://mail.python.org/mailman/listinfo/python-list