/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 vote209 views2 answers
How to take a screenshot of the pygame window and paste it
Python
0 vote112 views1 answer
Dtype cannot be bool python
Python
0 vote119 views1 answer
Date component
Python
1 vote117 views2 answers
Code help
Python
1 vote122 views1 answer
Fill pixels with zeros python opencv
Python
0 vote110 views1 answer
Pyspark groupby sum
Python
0 vote126 views1 answer
Python - Comment vérifier une corde est vide
Python
0 vote120 views1 answer
Creating base models django
Python
0 vote103 views1 answer
List Get a Element
Python
0 vote117 views1 answer
Python count how many times a character appears in a string
Python