/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

6 votes247 views2 answers
Add python kernel to Jupyter
Python
139 votes276 views6 answers
Anaconda create new environment
Python
1 vote248 views1 answer
How to clear checkbox in tkinter
Python
1 vote348 views3 answers
Ipynb to py online converter
Python
3 votes254 views3 answers
Flask migrate
Python
0 vote263 views1 answer
Sys.path[0]
Python
-1 vote237 views1 answer
Len
Python
10 votes274 views4 answers
Numpy distance between two points
Python
13 votes245 views1 answer
Python read file to variable
Python
1 vote264 views1 answer
Match python 3.10
Python