SQL update statement is: |
UPDATE tablename SET columnname = value WHERE condition |
To update the record with the front end form from the example above using a CFQUERY use this syntax: |
<CFQUERY NAME="UpdateEmployee" |
DATASOURCE="CF 3.0 Examples"> |
UPDATE Employees |
SET Firstname='#Form.Firstname#', |
LastName='#Form.LastName#', |
Phone='#Form.Phone#' |
WHERE Employee_ID=#Employee_ID# |
</CFQUERY> |