/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 vote159 views1 answer
How do i add new items to a dictionary within a for loop python
Python
-1 vote152 views1 answer
Django email verification
Python
11 votes142 views2 answers
Use regex python without re
Python
-1 vote138 views1 answer
Car python program
Python
5 votes135 views3 answers
Print complete dataframe pandas
Python
0 vote156 views1 answer
Fluffy ancake recipe
Python
2 votes150 views1 answer
Dictionary with numbers python
Python
1 vote153 views1 answer
Python rickroll code
Python
0 vote135 views1 answer
Discertize dara python
Python
0 vote155 views1 answer
Trends in yearly data python
Python