/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 vote216 views2 answers
Shared memory python
Python
0 vote179 views1 answer
How to convert tuple to int in python
Python
0 vote211 views1 answer
Python series to list of string
Python
0 vote231 views1 answer
Check if a date is reached django
Python Django
6 votes223 views3 answers
No matching distribution found for tensorflow==2.2.0
Python
0 vote204 views2 answers
Pandas series filter by index
Python
0 vote197 views1 answer
Matplotlib display axis in scientific notation
Python
15 votes213 views3 answers
Divide list into equal parts python
Python
5 votes209 views3 answers
Extract zip file python
Python
0 vote214 views1 answer
Python json web request
Python