Updating database with sql statement
The SQL UPDATE statement is more flexible for complicated updates.
The following procedure assumes that you have created the update_page as described in Creating an update action page with cfupdate.
Your form only needs to have fields for the database fields that you want to change. Contract to No if it is not defined, or to Yes if it is defined. The SELECT clause displays the table before the updates. The FROM clause specifies EMPLOYEES as the table to select from. The UPDATE statement updates the values in EMPLOYEES.