/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 vote148 views1 answer
Python set timezone windows
Python
21 votes154 views4 answers
Get list input from user in python
Python
3 votes136 views1 answer
How to time a python script
Python
0 vote146 views1 answer
Delete add replace conttent from csv by using python
Python
1 vote179 views1 answer
Get wav file in dir
Python
2 votes132 views1 answer
Combine df columns python
Python
6 votes126 views4 answers
Pandas rename multiple columns
Python
1 vote141 views1 answer
Grouping products for sales
Python
30 votes158 views6 answers
List comprehension if else
Python
0 vote136 views1 answer
Open url from ipywidgets
Python