/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 vote220 views1 answer
Spark write progress bar jupyter
Python
0 vote214 views1 answer
Python tex box
Python
0 vote212 views1 answer
Find position of key in dictionary python
Python
0 vote223 views1 answer
Pytorch older versions
Python
1 vote226 views2 answers
Is : and :: the same in python slice
Python
-1 vote229 views1 answer
Ovh minecraft
Python
0 vote221 views1 answer
Cs50 templating urls
Python
0 vote216 views1 answer
Pandas dataframe from array of dict
Python
0 vote222 views1 answer
Exception Value: Object of type User is not JSON serializable
Python
3 votes230 views2 answers
Extract pdf with python
Python