I am performing a series of deletes from several tables and one selection. It
does catch the an error however, it commits all the deletes exception the one
that threw the error. Why?
Here is the mock up of my code:
<CFSET Commit = "Yes">
<CFSET errCount = 0>
<CFSET arrErrorMessage = ArrayNew(1)>
<!--- Get FSubFeatureID form CS_SubServices table used to detetmine if a
section has contact information --->
<CFQUERY name="GetAllSubServiceID" DATASOURCE="DSN">
<CFSET Commit = "No">
<CFSET errCount = errCount + 1>
<CFSET arrErrorMessage[errCount] ="Unable to retrieve SubServiceID from
table1. Please contact ...