MySQLdb warnings problem

Gerhard Häring gerhard at bigfoot.de
Sun Jun 9 13:28:51 CEST 2002


* Gerhard Häring <gh_pythonlist at gmx.de> [2002-06-09 13:22 +0200]:
> Ok, so let's rewrite this to the appropriate form:
> 
>     sqlcmd= """UPDATE user SET nposts=%d, nrecent=%d, keytopic='%s'
>                WHERE username='%s'"""

     sqlcmd= """UPDATE user SET nposts=%d, nrecent=%d, keytopic=%s
                WHERE username=%s"""

_Without_ the single quotes, of course :)

>     dbcursor.execute(sqlcmd, (n_posts, n_recent, keytopic, user[0]))

Gerhard
-- 
mail:   gerhard <at> bigfoot <dot> de       registered Linux user #64239
web:    http://www.cs.fhm.edu/~ifw00065/    OpenPGP public key id AD24C930
public key fingerprint: 3FCC 8700 3012 0A9E B0C9  3667 814B 9CAA AD24 C930
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))





More information about the Python-list mailing list