/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

0 vote140 views1 answer
Pillow rgb to grayscale
Python
0 vote145 views1 answer
Make my own rabbit bomb using python
Python
0 vote141 views1 answer
Macos youtube-dl unable to get local issuer certificate _ssl.c:1131
Python
1 vote98 views1 answer
Python replace part in large file
Python
4 votes156 views4 answers
Jupyter lab autocomplete
Python
-1 vote207 views1 answer
Matplotlib draw a line between two points
Python
0 vote157 views1 answer
How to close ursina screen
Python
0 vote138 views1 answer
Remove tab space from string in python
Python
0 vote179 views1 answer
Open file rw python
Python
0 vote138 views1 answer
Reate the "soup." This is a beautiful soup object:
Python