/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 vote325 views10 answers
Scrapy itemloader example
Python
1 vote351 views2 answers
Left click pyautogui
Python
1 vote349 views1 answer
Read excel date in python
Python
0 vote340 views1 answer
What are data types in python
Python
103 votes390 views6 answers
Install opencv python
Python
2 votes343 views1 answer
Tensorflow for python 3.9
Python
0 vote335 views1 answer
Pandas define how you want to aggregate each column
Python
0 vote348 views1 answer
Default orange and blue matplotlib
Python
1 vote341 views1 answer
Flask enumerate index
Python
42 votes336 views4 answers
Replace column values pandas
Python