/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 vote231 views1 answer
Find charechtar index in string python
Python
0 vote270 views1 answer
Mathplolib avec date
Python
0 vote246 views1 answer
Open a web page using selenium python
Python
0 vote241 views2 answers
Python convert comma separated list of number to float
Python
1 vote271 views2 answers
Remove first element from list
Python
0 vote252 views1 answer
Write a Python program to get the Fibonacci series between 0 to 50. Note : The Fibonacci Sequence is the series of numbers
Python
47 votes257 views5 answers
Sort the dictionary in python
Python
8 votes247 views1 answer
Positive lookahead regex python
Python
3 votes248 views2 answers
How to change value of categorical variable in python
Python
2 votes221 views1 answer
Python download s3 image
Python