Postgresql update command fails

QuestionsPostgresql update command fails
Ron Swift asked 2 months ago

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
Abu Ghufran Staff answered 2 months ago

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?

Abu Ghufran - Dev Team
PHP Grid Framework
Ronald Swift answered 2 months ago

null value for some datetime fields was causing the error. I have since set that field as not editable and the edit update works.


Your Answer

7 + 1 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!