User Guide

482 Chapter 21: Updating Your Database
<tr>
<td>Contractor:</td>
<td><cfif #Contract# IS "Yes">
<input type="checkbox" name="Contract" checked>Yes
<cfelse>
<input type="checkbox" name="Contract">Yes
</cfif></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="Submit" value="Update Information"></td>
</tr>
</form>
</table>
</cfoutput>
</body>
</html>
2. Save the file as update_form.cfm.
3. View update_form.cfm in your web browser by specifying the page URL and an Employee ID;
for example, enter the following:
http://localhost/myapps/update_form.cfm?Emp_ID=3
Note: Although you can view an employee’s information, you must code an action page before
you can update the database. For more information, see “Creating an action page to update data”
on page 483.
Reviewing the code
The following table describes the code and its function:
Code Description
<cfquery name="GetRecordtoUpdate"
datasource="cfdocexamples">
SELECT * FROM Employee
WHERE Emp_ID = #URL.Emp_ID#
</cfquery>
Queries the cfdocexamples data source
and returns records in which the
employee ID matches what was entered
in the URL that called this page.
<cfoutput query="GetRecordtoUpdate">
...
</cfoutput>
Makes available as variables the results
of the GetRecordtoUpdate query in the
form created in subsequent lines.
<form action="update_action.cfm" method="Post">
...
</form>
Creates a form whose variables will be
processed on the update_action.cfm
action page.
<input type="Hidden" name="Emp_ID"
value="#Emp_ID#"><br>
Uses a hidden input field to pass the
Emp_ID (primary key) value to the action
page.