Creating an Update Form

An update form is similar to an insert form, but there are two key differences:

Note To create an update form:
  1. Create a new page in Studio.
  2. Edit the page so that it appears as follows:
    <CFQUERY NAME="GetRecordtoUpdate"
        DATASOURCE="CompanyInfo">
        SELECT *
            FROM Employees
            WHERE Employee_ID = #URL.Employee_ID#
    </CFQUERY>
    
    <HTML>
    <HEAD>
        <TITLE>Update Form</TITLE>
    </HEAD>
    <BODY>
    
    <CFOUTPUT QUERY="GetRecordtoUpdate">
    <FORM ACTION="UpdatePage.cfm" METHOD="Post">
    <INPUT TYPE="Hidden" NAME="Employee_ID"
        VALUE="#Employee_ID#"><BR>
        First Name: 
        <INPUT TYPE="text" NAME="FirstName" VALUE="#FirstName#"><BR>
        Last Name: 
        <INPUT TYPE="text" NAME="LastName" VALUE="#LastName#"><BR>
        Department Number: 
        <INPUT TYPE="text" NAME="Department_ID" 
    VALUE="#Department_ID#"><BR>
        Start Date: 
        <INPUT TYPE="text" NAME="StartDate" VALUE="#StartDate#"><BR>
        Salary: 
        <INPUT TYPE="text" NAME="Salary" VALUE="#Salary#"><BR>
        Contractor: 
        <INPUT TYPE="Submit" VALUE="Update Information">
    </FORM>
    </CFOUTPUT>
    
    </BODY>
    </HTML>
    
  3. Save the page. as updatedorm.cfm.
  4. View updateform.cfm in a browser.

Code Review
Code Description
<CFQUERY NAME="GetRecordtoUpdate"
    DATASOURCE="CompanyInfo">
    SELECT *
        FROM Employees
        WHERE Employee_ID = #URL.Employee_ID#
</CFQUERY>
Query the CompanyInfo datasource and return the records in which the employee ID matches what was entered in the URL.
<CFOUTPUT QUERY="GetRecordtoUpdate">
Display the results of the GetRecordtoUpdate query.
<FORM ACTION="EmployeeUpdate.cfm" METHOD="Post">
Create a form whose variables will be process on the EmployeeUpdate.cfm action page.
<INPUT TYPE="Hidden" NAME="Employee_ID"
    VALUE="#Employee_ID#"><BR>
Use a hidden input field to pass the employee ID to the action page.
First Name: <INPUT TYPE="text" NAME="FirstName" 
VALUE="#FirstName#"><BR>
Last Name: <INPUT TYPE="text" NAME="LastName" 
VALUE="#LastName#"><BR>
Department Number: <INPUT TYPE="text" 
NAME="Department_ID" VALUE="#Department_ID#"><BR>
Start Date: <INPUT TYPE="text" NAME="StartDate" 
VALUE="#StartDate#"><BR>
Salary: <INPUT TYPE="text" NAME="Salary" 
VALUE="#Salary#"><BR>
Contractor: <INPUT TYPE="checkbox" name="Contract" 
value="Yes" checked>Yes<BR><BR>

    <INPUT TYPE="Submit" VALUE="Update Information">
</FORM>
</CFOUTPUT>
Populate the fields of the update form.