[mod_python] Very frustrating problem... MySQL UPDATE syntax

Glenn Hochberg gah at research.att.com
Mon Nov 8 12:16:42 EST 2004


Perhaps this was just a mis-swipe in the email, but it looks like 
there's no passwd specified for db_query_update().

If that's not it, you might want to try adding a "c.fetchall()" after 
the "c.execute(query)"--perhaps the update is terminating because 
you're not reading back the result.

	-Glenn Hochberg

On Nov 8, 2004, at 6:32 AM, mod_python-request at modpython.org wrote:

> def db_query_update(query):
>         db = MySQLdb.connect(user='root', host='localhost',
> db='imagehost')
>         c = db.cursor()
>         c.execute(query)
>         c.close()
>         db.close()



More information about the Mod_python mailing list