TypeError: not enough arguments for format string?

Question

I have a list which I get from the form:

hobby = request.form.getlist('hobby')

The list is something like:

hobby = [sports, music, coding]

I would like to store this list in mysql server, so I have tried:

cursor.executemany('INSERT into hobby(list,a_id) VALUES(%s,%s)', (hobby, current_user.id))
return '<h1> Inserted </h1>'

Would it kill you to write a title that has more than 3 words and explains your problem concisely? (It's mentioned in the tour you seem to have gone through) — cs95
– cs95, Commented Dec 25, 2017 at 18:42
its showing TypeError: not enough arguments for format string — anoynmous
– anoynmous, Commented Dec 25, 2017 at 18:42
anoy.nmous ... please add the error message into the body of your question - NOT inside comments. — Patrick Artner
– Patrick Artner, Commented Dec 25, 2017 at 18:52
Do not call variables list, it overrides the list class reference. — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Dec 25, 2017 at 19:01

willeM_ Van Onsem · Accepted Answer · 2017-12-25 19:02:39Z

1

The cursor.executemany takes as second parameter an iterable of iterables. Every item will map to one time you execute the query. Every item then contains an iterable that contains the parameters to fill in.

So for this case, we should construct it like:

cursor.executemany('INSERT into hobby(list,a_id) VALUES(%s,%s)',
                   [(interest, current_user.id) for interest in interests])

N.B.: do not call variables things like list, since you will override the reference to the builtin list class. Here we named the list interests.

edited Dec 25, 2017 at 19:02

answered Dec 25, 2017 at 18:56

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

TypeError: not enough arguments for format string?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related