/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

5 votes109 views5 answers
Docstring in python
Python
3 votes163 views2 answers
Python check if list
Python
0 vote113 views1 answer
Return tuples form functions in Python
Python
0 vote109 views1 answer
Str.extract
Python
140 votes114 views3 answers
Windows python pip upgrade
Python
0 vote106 views1 answer
Qfiledialog python save
Python
1 vote141 views1 answer
Search in google with python
Python
21 votes108 views4 answers
Send message in specific channel discord.py
Python
12 votes102 views4 answers
Unzip in python
Python
0 vote150 views1 answer
Manage.py startapp not working in django
Python Django