/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

6 votes119 views1 answer
Enter key press bind tkinter
Python
133 votes90 views6 answers
Python input
Python
0 vote106 views1 answer
Python sns save plot lable axes
Python
1 vote125 views1 answer
Xpath helium
Python
1 vote116 views2 answers
How to find rows with missing data in pandas
Python
0 vote166 views1 answer
How to end a while loop python
Python
14 votes109 views5 answers
How to import modules in python
Python
2 votes115 views3 answers
Python common elements in two arrays
Python
1 vote136 views5 answers
How to install django in virtual environment in ubuntu
Python Django
0 vote101 views1 answer
Don't Get Volunteered!
Python