The ODBC data source is named "Employee DB," and the table you want to update is named "Employees." With the form example just described as the front end, the CFUPDATE tag would be included in your page as follows:
<CFINSERT DATASOURCE="Employee DB"
TABLENAME="Employees">
<!--- This is the page EmployeeUpdate.cfm --->
<CFUPDATE DATASOURCE="Employee DB"
TABLENAME="Employees">
<HTML>
<HEAD>
<TITLE>Reply</TITLE>
</HEAD>
<BODY>
<H2>Thank You!</H2>
<HR>
<P>Thank you for updating your data in
our database - please visit our site often!</P>
<HR>
</BODY>
</HTML>
|