/Python/Sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.

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

#Whats happening is that instead of getting the 1 datatype its looking for, 
#SQLite thinks its getting multiple. To solve this pass the data through as a 
#tuple, not on its own
cursor.execute('INSERT INTO images VALUES(?)', (data)) #should be
cursor.execute('INSERT INTO images VALUES(?)', (data,))
#To demonstrate, print the lengths of both of the options:
len(data)
>>>7
len(data,)
>>>1

Similar codes

33 votes319 views3 answers
Pygame draw circle
Python
0 vote289 views1 answer
Radio button selected event
Python
1 vote336 views1 answer
Get from time secs and nsecs
Python
0 vote310 views1 answer
Back of list
Python
0 vote310 views1 answer
Install gTTs
Python
0 vote337 views1 answer
Python cursor placement
Python
0 vote316 views1 answer
Kivy button on click
Python
37 votes342 views6 answers
Arrays python
Python
0 vote323 views6 answers
ORing two cv mat objects
Python
0 vote325 views1 answer
Use iloc to loop through dataframe
Python