Ok I am stuck. I am trying to catch any database errors that may happen. Here
is what I have so far.
<cfif isDefined("FORM.Submit") >
<cftry>
<cfquery name="eqptid" datasource="#datamain#">
select eqptid from eqpt where serialno='#form.txtSerial#'
</cfquery>
<cfcatch type="Database">
<cfoutput><strong>The serial number entered was not found in
the database. Please click the back button on the browser and try again.
</strong>
<strong> <br /> If this is your second attmept please send all
information to Sam Garcia. I will enter all information manually.</strong>
</cfoutput>
<cfabort>
</cfcatch>
</cftry>
so long as the correct serial number is entered everything works great. The
catch block is not catching any errors. When I get the catch block to work
nothing else works.
Sam
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4437
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
