/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

1 vote328 views1 answer
Length of a matrix in python
Python
2 votes351 views1 answer
Functions python examples
Python
15 votes300 views4 answers
Django python install
Python
4 votes304 views3 answers
How to change port in flask app
Python
36 votes323 views3 answers
Python image library
Python
5 votes308 views1 answer
Rolling average df
Python
0 vote296 views1 answer
Pandas separator are multiple spaces
Python
0 vote335 views1 answer
Change heading treeview tkinter
Python
0 vote315 views1 answer
Numpy prod
Python
14 votes338 views1 answer
Create data dir in python
Python