> 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?
I don't remember it offhand. I'm not exactly sure what you mean. Do you mean
something that would create an empty query object if a query fails?
<cftry>
<cfquery name="somequery" ...>
SELECT ...
</cfquery>
<cfcatch type="database">
<cfset somequery = QueryNew(...)>
</cfcatch>
</cftry>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/
WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:299858
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4