<cftry>
<cfquery name="get_this" datasource="arf">
select * from sys_note_type
</cfquery>
<cfcatch type="Database">
<cfif findnocase("Data source arf could not be found.",cfcatch.message)>
Please Come back later
</cfif>
</cfcatch>
</cftry>
-----Original Message-----
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 10:12 AM
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]
