Skip navigation links

MySQL Forums :: Connector/Python :: Wrong number of arguments during string formatting


Advanced Search

Wrong number of arguments during string formatting
Posted by: Dan Survivalist ()
Date: March 05, 2013 05:20PM

Been working on a project with the MySQL connector and it's been pretty painful. The docs don't seem to be very complete...

(1) Does dict substitution work if the same value appears multiple times? It seems not to. For example:

INSERT INTO some_table ( id, name ) VALUES ( %(id)s, %(name)s) ) ON DUPLICATE UPDATE some_table SET name = %(name)s WHERE id = %(id)s

Here name is used once, though it's only in the dict once of course.

This has inevitably lead to mysql.connector.errors.ProgrammingError: Wrong number of arguments during string formatting

(2) Is only %s supported? What if I'm inserting into a column that is INTEGER? Use of %i gives the same error. Which leads to goofy things like VALUES ( %s + 0 )

Options: ReplyQuote


Subject Written By Posted
Wrong number of arguments during string formatting Dan Survivalist 03/05/2013 05:20PM
Re: Wrong number of arguments during string formatting Geert Vanderkelen 03/12/2013 05:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.