User Guide

64 Developing Web Applications with ColdFusion
<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.