/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 vote185 views1 answer
How to check type inside a list in python
Python
9 votes173 views6 answers
Python sort list
Python
1 vote216 views1 answer
Django filter not equal to
Python Django
12 votes212 views1 answer
Python copy ddictionary
Python
0 vote206 views1 answer
Python open all files of type csv
Python
0 vote242 views1 answer
Matplotlib bar chart value_counts
Python
1 vote180 views1 answer
Pydotprint
Python
4 votes163 views2 answers
Remove all 0 from list python
Python
0 vote169 views1 answer
Spansk dansk
Python
0 vote184 views1 answer
Add one element to tuple python
Python