Python Sqlite3 Update query not working

Question

I'm trying to compare the prices of some products stored on my database, while the comparison works fine, the update statement doesn't seem to update the desired field.

for currentRow,newRow in zip(currentInfo,newInfo):

    if currentRow[1]!=newRow[1]:
        print(currentRow[0],newRow[0])
        print("The price of %s has changed from %s to %s" %    (currentRow[0], currentRow[1], newRow[1]))
        db.execute("update table set Prices=? where Product=?",(newRow[1],currentRow[0]))
        conn.commit

@lmiguelvargasf I'm really embarrassed...I forgot to add the parenthesis. Thank you for your time — Volpym
– Volpym, Commented Feb 9, 2017 at 17:27

Cody Myers · Accepted Answer · 2017-02-09 19:58:31Z

2

I think you just missed the ().

conn.commit()

answered Feb 9, 2017 at 19:58

Cody Myers

3512 silver badges5 bronze badges

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

1 Comment

Reddspark Over a year ago

Thanks - helped me too. The fact it doesn't give any error message is confusing.

Collectives™ on Stack Overflow

Python Sqlite3 Update query not working

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related