I am trying to execute following python code:
conn = sqlite3.connect("db")
conn.row_factory = sqlite3.Row
cursor = conn.cursor()
change_list = ["a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "ka", "ko"]
for change in change_list:
rows = cursor.execute("select * from determine_image where modification_type = ?", (change)).fetchall()
for row in rows:
print (row)
but all I get is the following error:
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 12 supplied.
I do not understand why I get that error, would you kindly tell me why I am getting this error and how to solve it?
I am using python 2.7 and sqlite3