I am having conn.Commit error how to fix that

Asked Oct 13 '22 at 06:22

Active Oct 13 '22 at 06:46

Viewed 9 times

conn.commit() ^ SyntaxError: invalid syntax [Finished in 451ms]

i am having the above and i am new to this and not able to understand how to fix that

with conn.cursor() as cur:
        if eco.shape[0]>0:
            for i in range(len(eco)):
                cur.execute('''update repairOperation_ecotraveler set part_number = {0},current_revision = {1},upgrade_revision = {2},eco = {3},description = {4} where id = {5};'''.format((eco[part_number][i], eco[current_revision][i], eco[upgrade_revision][i], eco[eco][i], eco[description][i])))
                conn.commit()

edited Oct 13 '22 at 06:46

asked Oct 13 '22 at 06:22

vidathri

You're missing a closing parentheses `)` at the end of the line that begins `cur.execute(...` – Iain Shelvington Oct 13 '22 at 06:26

I am having conn.Commit error how to fix that

0 Answers0