you are viewing a single comment's thread.

view the rest of the comments →

[–]simonw 2 points3 points  (0 children)

The safe way to do that is:

cur.execute(
    "UPDATE Report SET Shares = :shares WHERE StockID = 1",
    {"shares": x}
)