How can I insert a Python variable in a sqlite query?

Question

I'm looking for the way to be able to compare what is in a Python variable with something in a SQLite query.

For example:

num = input ("enter a number")
cur.execute("SELECT a.Name,a.Number FROM Ads a WHERE a.Number = (num)")
row = cur.fetchone()
while row:
    print(row) 
    row = cur.fetchone()

The cur.execute line doesn't work. I don't know how to be able to compare content of a Python variable with data in a SQLite database via a SQlite query.

Mike Bessonov · Accepted Answer · 2015-04-03 22:44:32Z

5

You put a '?' as a place holder for each Python variable, something like

num = 5
cur.execute("SELECT Name, Number FROM Ads WHERE Number = ?", (num,))

The execute() method expects a sequence as a second argument, since several '?' positional placeholders can be used in the SQL statement.

answered Apr 3, 2015 at 22:44

Mike Bessonov

6863 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I insert a Python variable in a sqlite query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related