/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 vote178 views1 answer
Delete dataframe from memory python
Python
39 votes181 views2 answers
Pandas how to get last index
Python
0 vote217 views1 answer
Python path from string
Python
0 vote219 views1 answer
General Loop Structure
Python
0 vote233 views1 answer
Random module randint
Python
1 vote192 views1 answer
Dict to excel without external library
Python
39 votes192 views6 answers
Random list python
Python
0 vote196 views1 answer
Dataframe fill none
Python
1 vote195 views3 answers
Python nested list
Python
0 vote195 views1 answer
Is dictreader scoped in python
Python