I have to following piece of code:
temp = item.get() #returns a string
c.execute("INSERT OR IGNORE INTO {tn} ({cn}, {dn}, {en}) VALUES (?, 23, 10)".\
format(tn=table_name, cn=field2, dn = field3, en = field4), (temp))
However, the code causes an error:
File "First_GUI.py", line 47, in func_confirm
format(tn=table_name, cn=field2, dn = field3, en = field4), (temp))
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current
statement uses 1, and there are 0 supplied.
Do you have any idea how I can fix the syntax?