Welcome to python-forum.io

Results

Search Results

Post

Author

Forum

Replies

Views

Posted [asc]

Thread: Error 1064 (42000) when executing UPDATE SQL
Post: RE: Error 1064 (42000) when executing UPDATE SQL

Solved!!!!!! It was the mixture of 2 errors: On the one hand, the product_id was a text string that had characters that were not numbers. On the other hand I had forgotten to use connection.commit()...

gratiszzzz

General Coding Help

1,601

May-22-2023, 01:31 PM

Thread: Error 1064 (42000) when executing UPDATE SQL
Post: RE: Error 1064 (42000) when executing UPDATE SQL

Yeah. I had also thought about it and tried with ";" and without ";". But nothing, it looks like the same error... I'll keep testing until I find the error... Thank you very much for your help. If I ...

gratiszzzz

General Coding Help

1,601

May-22-2023, 09:11 AM

Thread: Error 1064 (42000) when executing UPDATE SQL
Post: RE: Error 1064 (42000) when executing UPDATE SQL

(May-22-2023, 07:18 AM)ibreeden Wrote: Which database are you using? Please show us your program and the complete error message. You are calling execute_query(). Where is it defined? Hi ibreeden! ...

gratiszzzz

General Coding Help

1,601

May-22-2023, 07:42 AM

Thread: Error 1064 (42000) when executing UPDATE SQL
Post: RE: Error 1064 (42000) when executing UPDATE SQL

sql_actualizar_ficha_es = "UPDATE ps_product_lang SET description = '--', name = '" + titulo + "' WHERE id_product = " + id_producto + " AND id_lang = 1;" sql_actualizar_ficha_pt = "UPDATE ps_prod...

gratiszzzz

General Coding Help

1,601

May-21-2023, 11:17 PM

Thread: Error 1064 (42000) when executing UPDATE SQL
Post: Error 1064 (42000) when executing UPDATE SQL

Good afternoon: I am trying to run an UPDATE query in SQL from python. I think the statement is correct, but it constantly returns an error. I do not know what to do... -----------------------------...

gratiszzzz

General Coding Help

1,601

May-21-2023, 11:12 PM

Results

User Panel Messages

Announcements