When UPDATE the TABLE using python and sqlite ,, I am getting this error --Incorrect number of bindings supplied [duplicate]

Question

I am getting this error --

Incorrect number of bindings supplied The current statement uses 4, and there are 3 supplied.

Here is the code --

def update_entry(self):
     self.cur.execute('UPDATE SINGLE SET IN=?,OUT=?,QUALITY=? WHERE ID=?',
 (self.IN_entry.get(),self.OUT_entry.get(),self.QC_entry.get()))

blhsing · Accepted Answer · 2018-09-09 13:09:04Z

0

You have 4 placeholders in your query and yet you're supplying only 3 items in the tuple passed to execute. You should supply a value for the placeholder for ID as the 4th item in the tuple.

answered Sep 9, 2018 at 13:09

blhsing

109k9 gold badges88 silver badges132 bronze badges

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

Collectives™ on Stack Overflow

When UPDATE the TABLE using python and sqlite ,, I am getting this error --Incorrect number of bindings supplied [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related