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

Reply via email to