/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 votes152 views1 answer
Native bold text
Python
30 votes147 views3 answers
How to replace null values in pandas
Python
5 votes133 views2 answers
List files in directory python with extension
Python
0 vote175 views1 answer
Item[0]: (i + 1) * 2 for i, item in (sort_loc)
Python
1 vote140 views2 answers
Python dict dot notation
Python
1 vote170 views1 answer
Python ascii caesar cipher
Python
1 vote167 views1 answer
How to make a kivy label multiline text
Python
0 vote148 views1 answer
Cbind arrays python
Python
0 vote141 views1 answer
Django amzon like app
Python
3 votes146 views1 answer
Python ftp upload file
Python