Syntax error with placeholder in python with sqlite INSERT command

Question

I am getting an error with the second placeholder on MySQL query:

photo_number_value = c.execute('INSERT into ebay VALUES (?,?)', photo_number_key,photo_number)

the error that I'm getting is:

unexpected argument

tdelaney · Accepted Answer · 2016-01-23 02:03:44Z

3

Syntax errors and "unexpected argument" errors are different things. But since execute only takes two parameters, I'll go with the latter. You need to put the parameter values into a list or tuple to make it work:

photo_number_value = c.execute('INSERT into ebay VALUES (?,?)',
    (photo_number_key,photo_number))

answered Jan 23, 2016 at 2:03

tdelaney

77.9k6 gold badges91 silver badges129 bronze badges

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

Collectives™ on Stack Overflow

Syntax error with placeholder in python with sqlite INSERT command

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