An update form is similar to an insert form, but there are two key differences:
A primary key is a field or combination of fields in a database table that uniquely identifies each record in the table. For example, in a table of employee names and addresses, only the Employee_ID would be unique to each record.
![]() |
To create an update form: |
<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>
updatedorm.cfm
.
updateform.cfm
in a browser.
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"> | Populate the fields of the update form. |