Pseudo-code:
<cftry>
<cfquery name="somequery" Datasource="somedts">
SELECT *...
</cfquery>
<cfcatch type="Database">
<cfset somequery = QueryNew()>
</cfcatch>
</cftry>
Something like this?
!k
-----Original Message-----
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Monday, February 25, 2008 2:31 PM
To: CF-Talk
Subject: Watts' try/catch query example
I remember a while back Dave Watts posted an example of using a try catch to
ensure a query always exists if it errors.
Can't find it in the archives?
Any one remember that? Dave?
Thanks,
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299857
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4