/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 vote369 views1 answer
Lineplot in plt
Python
0 vote395 views1 answer
What is a good django orm cookbook
Python Django
1 vote350 views1 answer
Werkzeug.datastructures.filestorage to numpy
Python
0 vote309 views1 answer
Flask migrate multiple heads
Python
1 vote308 views1 answer
Open excel through python
Python
0 vote322 views1 answer
How to scale an array between two values python
Python
0 vote351 views1 answer
Dataframe fill none
Python
0 vote329 views1 answer
How to convert word to number in python pandas
Python
1 vote321 views1 answer
Truncate add weird symbols in python
Python
1 vote374 views1 answer
Elif in django template
Python Django