Use try catch on a query that you know will work (and is fast) if it is
online. You can even throw an error and use cferror for the display of
the message. Or you can use try catch on the query itself.
-----Original Message-----
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: maandag 24 november 2003 16:12
To: CF-Talk
Subject: Testing DSN's before processing queries

Does anyone know a method to test a DSN before running a query?  We link
to an AS/400 DSN which is occasionally offline for backups, maintenance,
etc.  I'd like to run a test that if the DSN isn't working will display
a "Please come back later" message.   Any suggestions?

Thanks,
Daron Smith
  _____  


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to