Hi... simple test
mysql cmd - select * from foo where dog like "%small%"; sql ="""select * from foo where dog like "%%%s%%" """ c.execute(sql, (var,)) the above doesn't work, and I can't seem to figure out how to display/print out the sql as i't actually been excuted, so I can see where the issue is. i've tried to "/" escape, as well as a few other things, now of which shed any light on the issue. haven't found any information via google either. the above works if i have something like sql="""select * from foo where dog=%s""" c.execute(sql,(var,)) so.. any help/pointers on what i've screwed up/missed would be helpful. thanks -- http://mail.python.org/mailman/listinfo/python-list
