/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

2 votes314 views1 answer
Dataframe from two series
Python
0 vote270 views1 answer
Python enumerate to skip items
Python
0 vote257 views2 answers
Python print list in dictionary
Python
0 vote262 views1 answer
Bs
Python
109 votes262 views6 answers
Python string contains
Python
71 votes223 views1 answer
Small python projects for beginners
Python
0 vote301 views1 answer
C++ vs python
Python
0 vote256 views1 answer
\u00a0
Python
1 vote273 views2 answers
Check if user has manage messages discord.py
Python
4 votes295 views4 answers
Python Docstrings Example
Python