I am trying to update a table (customerorder) for columns CustomerID, DelDate,DelTime and TotalCost - in row where (in this example) Key OrderID = 323. The function 'UpdateCustomerOrderinfo' below is used within the action page which supports the input form.
The error message below indicates some subtle syntax code. Hopefully you might spot it.
Tks for any assistance
SET CustomerID=%s, DelDate=%s, DelTime=%s, TotalCost=%s
""", (CustomerID, DelDate, DelTime, TotalCost, OrderID))
rs.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HAVING OrderID='423'' at line 3