/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 vote157 views1 answer
Assigning values in python
Python
0 vote143 views1 answer
Foreign key django createview
Python
5 votes119 views2 answers
Change space to underscore python
Python
1 vote166 views1 answer
Matplotlib x axis at the top
Python
0 vote173 views1 answer
Flow of control in python
Python
0 vote168 views1 answer
Poppler on colab
Python
0 vote166 views1 answer
Merge subplot matplotlib
Python
0 vote156 views1 answer
How to delete all instances of a model in django
Python
1 vote161 views1 answer
Slicing strings in python
Python
0 vote148 views1 answer
Python return min length of list
Python