/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 vote348 views1 answer
Cos2x
Python
1 vote369 views1 answer
Python list add if not present
Python
3 votes359 views1 answer
Get column index pandas
Python
17 votes366 views2 answers
Make password python
Python
0 vote363 views1 answer
Fetch json array from mysql django
Python Django
34 votes345 views6 answers
Simple flask app
Python
1 vote349 views1 answer
Python months between two dates
Python
139 votes364 views6 answers
Anaconda create new environment
Python
0 vote365 views1 answer
Python set attribute by string name
Python
1 vote346 views1 answer
Matplotlib change font
Python