I'd do a try and catch with a stored procedure with a SELECT query. That way you could turn the procedure debug on and returncode on. Then you could handle the return code on the cf side to send the user to the proper template with a switch statement. I'm using it now because we have a tempermental database that frequently takes 3100 ms or greater to return a query, and sometimes not at all.
Hope that helps. Dreamweaver's documentation of the <cfstoredproc> tag has some good help.
- Irvin
On May 6, 2005, at 10:29 AM, Moro, Giovanni wrote:
Howdy Folks,
I was wondering if anyone can point me to, or provide an example of
testing the DB connection.
I often pull from two different databases and sometimes we run into
issues with the one we have no control over. I'm looking for a quick way to
test the connection so I can provide a more adequate error message to the
user.
Thanks.
--Giovanni
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at www.mail-archive.com/ [email protected]
---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm
An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
