sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 202 supplied

Question

Hi I'm trying to implement a submit order function for a homework assignment in python

def order_submitted():
for item in cartproducts:
    c.execute("INSERT INTO orders(Product_Name) VALUES(?);", str((cartproducts,)))
c.commit()

This is the code I currently have and I have no idea why I am getting the Incorrect number of bindings error, I've looked at the other posts about this error, and tried the fixes to no avail, just wondering if anyone can see whats wrong with this code. Also I've tried the code without the str() but then I just run into another data type error.

ruohola · Accepted Answer · 2020-05-24 06:23:30Z

2

You are supplying the whole list converted to a string as the parameter values for the query. It should instead be something like this:

def order_submitted():
    for item in cartproducts:
        c.execute("INSERT INTO orders(Product_Name) VALUES(?);", (item, ))
    c.commit()

edited May 24, 2020 at 6:23

answered May 24, 2020 at 6:06

ruohola

24.8k7 gold badges76 silver badges118 bronze badges

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

4 Comments

DanielB Over a year ago

The executemany method may also be of interest.

azulu Over a year ago

If I could just ask you something else, now for my code I have to add in the prices for these items as well from a different list which is cartprices, how would I go about this? So far I've got

for item in cartproducts:         c.execute("INSERT INTO orders(Product_Name, Product_Price) VALUES(?,?);", (item, item, ))     connection.commit()

azulu Over a year ago

And obviously this just adds the same values from cartproducts into the Product_Price column

ruohola Over a year ago

What about:

for item, price in zip(cartproducts, cartprices): c.execute("INSERT INTO orders(Product_Name, Product_Price) VALUES(?,?);", (item, price, )) connection.commit()

Collectives™ on Stack Overflow

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 202 supplied

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related