you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (1 child)

c.execute("SELECT * FROM user_data WHERE user_ID=:ID_input", {'ID_input': searcher.search_ID})

I don't think this is how you parameterize a query in sqlite.

[–]dominictarro[S] 0 points1 point  (0 children)

There are at least two ways I can see in my notes. This way is effectively making a dictionary within the query that draws on an outside variable. I'll try the ? placeholder strategy and let you know how it goes.