>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
William Thanks for taking time to reply. After much reading last night, I believe I know the problem just not how to correct. When I enter a valid value everything runs fine. When I enter an invalid value I need to handle this exception. I think my query is returning a NULL value when an invalid value is entered on the form. There is no way to check this value on the form. See the users are updating a database and the serial number may not be in the database or simply entered incorrectly therefore the query returns a NULL value. I am forced to use an older version of ColdFusion 5.0 so I can not use isNULL() I am leaning toward using javascript to check for a NULL value. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4439 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
