/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 vote349 views1 answer
Scatter plot | create scatter plot
Python
5 votes316 views3 answers
Click a button using selenium python
Python
29 votes355 views2 answers
Python initialize array
Python
0 vote340 views1 answer
Use miraculous with enviroment variable token
Python
26 votes343 views2 answers
Dictionary from two list
Python
0 vote415 views1 answer
Python String to array using list() method
Python
1 vote333 views1 answer
Split a text file into multiple paragraphs python
Python
2 votes386 views1 answer
Python sys halt
Python
0 vote339 views1 answer
Transverse tensor in pytorch
Python
2 votes332 views1 answer
Python click buttons on websites
Python