Can you please elaborate on ''nothing else works"? You have this line in your code inside the cfcatch block: <cfabort>
This code will abruptly stop the entire code and send whatever was generated prior to it to the web browser. William ------------------ William E. Seiter Need to have your mortgage modified? I charge no fees until I am successful, then I charge almost half the rate you would find elsewhere. Professional. Dedicated. Effective. The Easy 24/7 way to get started: http://www.goldengrove.net/ or you can call: (626) 593 - 5501 -----Original Message----- From: Servando Garcia [mailto:[email protected]] Sent: Monday, March 09, 2009 2:37 PM To: cf-newbie Subject: CFTRY abd database query 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:4438 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
