/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 vote192 views1 answer
If function error grepper
Python
0 vote183 views1 answer
Np.split dataframe specific conditionm
Python
0 vote198 views1 answer
Rendere eseguibile python
Python
-1 vote383 views2 answers
Python timestamp to yyyy-mm-dd
Python
0 vote181 views1 answer
Change column row box colour tkinter
Python
6 votes192 views1 answer
How to simulate a key press in python
Python
1 vote224 views1 answer
How to iterate pyspark dataframe
Python
10 votes178 views2 answers
Python get absolute path of file
Python
23 votes186 views4 answers
Delete last few items from a list python
Python
-1 vote179 views2 answers
Python pynput space
Python