/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 vote195 views1 answer
Eia api python
Python
0 vote184 views1 answer
Kneighbours regressor sklearn
Python
0 vote181 views1 answer
Rename one dataframe column python in inplace
Python
0 vote167 views1 answer
Print chr character in python f string
Python
0 vote207 views1 answer
How to make game on python
Python
0 vote168 views1 answer
Feature scaling in python
Python
19 votes241 views1 answer
Python string cut to length
Python
0 vote174 views1 answer
Python - from most_similar to ldictionary
Python
8 votes185 views2 answers
Python foreach 2d array
Python
0 vote172 views1 answer
Python update flask
Python