/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 vote163 views1 answer
Access data frame element by loc
Python
0 vote154 views1 answer
Convert excel workbook to dataframe
Python
0 vote154 views1 answer
Django creat app return _bootstrap._gcd_import
Python Django
3 votes175 views1 answer
Python invert an array
Python
0 vote160 views1 answer
From decimal to binary python without using any libraries
Python
0 vote151 views2 answers
Days in month function python
Python
0 vote169 views1 answer
Adjusted price in crsp pandas
Python
86 votes193 views6 answers
Select random value from list python
Python
0 vote200 views1 answer
Python timedelta get days with fraction
Python
1 vote158 views1 answer
Fatal error detected failed to execute script
Python