<!--- Perform the update to the database table --->
<CFUPDATE DATASOURCE="OWS" TABLENAME="Merchandise">

<!--- Retrieve updated data back from the database --->  
<CFQUERY NAME="GetMerchandise" DATASOURCE="OWS">
  SELECT MerchID, MerchName, MerchDescription
  FROM Merchandise
  WHERE MerchID = #Form.MerchID#
</CFQUERY>

<!--- Delete the old record from the Verity collection --->
<CFINDEX ACTION="DELETE"
  COLLECTION="Merchandise"
  KEY="#Form.MerchID#">

<!--- Get updated version back into the Verity collection --->
<CFINDEX 
  ACTION="UPDATE"
  COLLECTION="Merchandise"
  TYPE="CUSTOM"
  QUERY="GetMerchandise"
  KEY="MerchID"
  TITLE="MerchName"
  BODY="MerchDescription"
>

<HTML>

<HEAD>
<TITLE>Update Complete</TITLE>
</HEAD>

<BODY>

<H2>Update Complete</H2>

</BODY>

</HTML>
