select with variable in PostgreSQL using python

Question

I'm tring to run select query in python where an id = to a number in a variable.

the following statement works from numbers 1 to 9

cur.execute("SELECT ex_id FROM live_orders WHERE lc_id = %s",lc_id)

any number more than or equal to 10 gives the following error

TypeError: not all arguments converted during string formatting

Thanks all.

theGtknerd · Accepted Answer · 2018-11-29 00:51:02Z

1

You are not passing in a tuple or list. Try this:

cur.execute("SELECT ex_id FROM live_orders WHERE lc_id = %s",[lc_id])

or this:

cur.execute("SELECT ex_id FROM live_orders WHERE lc_id = %s",(lc_id,))

answered Nov 29, 2018 at 0:51

theGtknerd

3,8131 gold badge17 silver badges38 bronze badges

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

1 Answer 1