sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 7, and there are 8 supplied. code example

Example: Incorrect number of bindings supplied. The current statement uses 1, and there are 3 supplied.

#You need to pass in a sequence, comma at the end:
cursor.execute('SELECT * FROM TABLE WHERE COL = ?;', (string,))