/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 vote278 views1 answer
Python import shelve
Python
1 vote262 views1 answer
Discord.py send messages
Python
0 vote296 views1 answer
Chi square test contingency table python
Python
13 votes313 views1 answer
Python read text file into string
Python
0 vote314 views1 answer
Make my own rabbit bomb using python
Python
0 vote298 views1 answer
Failed to build wxPython
Python
0 vote263 views1 answer
Print a string with spaces between characters python
Python
0 vote288 views1 answer
Python sns save plot lable axes
Python
13 votes344 views5 answers
How to check if a input is an integer python
Python
1 vote260 views1 answer
Selenium select element by id
Python