> If I've got a query and for some odd reason the database > server goes down, of course my query will fail. > How can I catch the error due to the server being down and display a > static/temp page instead? > My code is below and it appears to be correct but it will not > catch the error and redirect.
Remember that rubbish SQL will also cause a CFCATCH TYPE="database" to hit I'm working with the presumption you're using CF5, as I'm not 100% sure this works with CF4.x What I'd suggest is looping through the CFCATCH.TagContent array and see what's in there for different errors, that way you know if the dbServer is down, or if it's rubbish SQL Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
