Insert tuple in sqlite request

Asked Mar 23 '16 at 14:12

Active Mar 23 '16 at 16:50

Viewed 108 times

I have selected_comments which is a tuple of id that I want to remove from the sqlite3 database. I tried this command (and other variations):

cursor.execute("DELETE FROM comments WHERE id IN (?)",(selected_comments))

But I get errors (for this specific command, I have: sqlite3.ProgrammingError: Incorrect number of bindings supplied.).

The size of the tuple is not fixed: it can go from 1 element to as much as you want.

edited Mar 23 '16 at 16:50

asked Mar 23 '16 at 14:12

Shan-x

did you try putting it as just `selected_comments` and not `(selected_comments)`? – K DawG Mar 23 '16 at 14:53
Yes. And with `?` as well. – Shan-x Mar 23 '16 at 14:57
Have you tried ``(selected_comments,)`` instead of ``(selected_comments)``. – Ronald Oussoren Mar 23 '16 at 15:15
It was my first try. But `selected_comments` is already a tuple, so there is no need to add the comma. – Shan-x Mar 23 '16 at 15:45

0 Answers0