Not enough arguments in string, multiple IN clauses with list values in MySQL query from Python

Question

I have the below code a cannot get it to work once I add the second IN clause to filter on last names.

format_fname = ','.join(['%s'] * len(stFirstnames))
format_lname = ','.join(['%s'] * len(stLastnames))

curDox.execute("SELECT * FROM user WHERE firstname IN (%s) AND lastname IN (%s)" % format_fname,
                tuple(stFirstnames), format_lname,tuple(stLastnames))

Error I get is

TypeError: not enough arguments for format string

Bakhrom Rakhmonov · Accepted Answer · 2017-12-18 03:31:44Z

1

Try this:

format_fname = ', '.join(['\'%s\''] * len(stFirstnames))
format_lname = ', '.join(['\'%s\''] * len(stLastnames))

curDox.execute("SELECT * FROM user WHERE firstname IN (%s) AND lastname IN (%s)" % (format_fname % tuple(stFirstnames), (format_lname % tuple(stLastnames))))

answered Dec 18, 2017 at 3:31

Bakhrom Rakhmonov

7026 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Not enough arguments in string, multiple IN clauses with list values in MySQL query from Python

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related