/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 vote96 views1 answer
Os remove entire folder python
Python
0 vote294 views1 answer
How to assign value to variable in Python
Python
1 vote108 views1 answer
Django urlpattern
Python
5 votes100 views3 answers
Python if not
Python
1 vote91 views5 answers
Numpy argsort
Python
0 vote96 views2 answers
Loading images as sprites in pygame
Python
1 vote107 views1 answer
Pandas read_csv random rows
Python
0 vote578 views1 answer
Split string with first numerical value in python
Python
2 votes100 views2 answers
Django response headers
Python
0 vote90 views1 answer
Enumerate items python
Python