/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 vote246 views1 answer
Python second max in numpy array
Python
-1 vote226 views1 answer
What is mi casa in spanish
Python
0 vote274 views5 answers
Append in dictionary with matrix values
Python
0 vote269 views1 answer
Int and text on same line python
Python
0 vote279 views1 answer
Break py
Python
1 vote288 views1 answer
How to pronounce aesthetic
Python
2 votes280 views1 answer
Django template capitalize equivalent
Python
1 vote302 views1 answer
How to define dtype of each column before actually reading csv file
Python
6 votes277 views1 answer
Enter key press bind tkinter
Python
0 vote297 views1 answer
How to use ttk themes
Python