Re: Wrong number of arguments during string formatting

[Geert Vanderkelen]

(1) Here is prove that it does work:

>>> cnx = mysql.connector.connect(............)
>>> cur = cnx.cursor()
>>> cur.execute("SELECT %(name)s, %(name)s", {'name': 'ham'})
>>> cur.fetchall()
[(u'ham', u'ham')]

Please double check and if you believe you found a bug, report using bugs.mysql.com


(2) %s is a 'universal' placeholder. It's used for anything, strings, integers, datetime.datetime, .. (see PEP-249). If you provide an int, an int will be inserted.

Geert Vanderkelen
Software Developer at Oracle