/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

-1 vote212 views1 answer
Flask set mime type
Python Flask
4 votes198 views2 answers
Python press any key to continue
Python
0 vote146 views1 answer
Pandas dataframe row names
Python
0 vote156 views1 answer
Verilog import module
Python
1 vote174 views3 answers
Creat and active python environment
Python
0 vote248 views1 answer
Django admin.py all fields
Python Django
13 votes159 views3 answers
Python dynamic variable name
Python
1 vote148 views2 answers
Update to python 3.7
Python
0 vote109 views1 answer
How do I know which animation is playing animation player
Python
0 vote182 views1 answer
Python node class
Python