/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 vote120 views1 answer
Transparancy argument pyplot
Python
0 vote79 views1 answer
Multi argument python
Python
0 vote143 views1 answer
Save python dic
Python
0 vote113 views1 answer
Python how to get project location
Python
1 vote128 views1 answer
Fill python list with input
Python
11 votes123 views2 answers
Add pip to path
Python
-2 votes125 views1 answer
Client server python socket
Python
2 votes133 views2 answers
How to save a png seaborn pandas
Python
0 vote110 views1 answer
Python var_dump
Python
0 vote129 views1 answer
'datetime.date' object has no attribute 'split'
Python