0

I have a table created like this:

cursor.execute("CREATE TABLE program_types (program_type_id INTEGER PRIMARY KEY ASC, program_type TEXT);")

I populate it like this:

cursor.execute("INSERT INTO program_types VALUES(NULL, ?);", ("blah"))

And it gives me this error:

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 4 supplied.

If I switch the number of characters, as in:

cursor.execute("INSERT INTO program_types VALUES(NULL, ?);", ("blahblah"))

The number of bindings sql finds increases to match the number of characters in the bound string:

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

Any help would be greatly appreciated!

0 Answers0