When attempting to edit/update rows from Postgresql with Phpedit, I am getting an error:
Couldn’t execute query. ERROR: syntax error at or near “=” LINE 1: UPDATE SET “customernumber”=’1001655′,”weekenddate”=’2018-0… ^ – UPDATE SET “customernumber”=’1001655′,”weekenddate”=’2018-04-22 00:00:00′,”latepaydate”=”,”invoicedate”=’2018-04-23 00:00:00′,”invoiceamount”=’150′,”lateinvoicedate”=’2018-05-24 00:00:00′,”lateinvoiceamount”=’160.5′,”po”=” WHERE “invoiceid” IN (‘32779’)
2 Answers
I can’t figure whats exactly wrong in this query. Can you run it on DB IDE and tell which part of query is incorrect and correct alternate?
Your Answer