> Dave, thanks for the reply. I won't bore you with details,
> but suffice it to say that we prefer getting empty recordsets
> back in some cases because it makes our overall error
> handling and application flow better--granted, perhaps to the
> detriment of application performance. However, for us the
> trade-off has been well worth it to this point.
<cftry>
<cfquery name="qWhatever" ...>
...
</cfquery>
<cfcatch type="database">
<cfset qWhatever = QueryNew(...)>
</cfcatch>
</cftry>
Voila! Empty recordset!
> In the cases where it does increase performance, does it do
> so because SQL bind variables are used?
Yes, and in the cases where it decreases performance, it's for the same
reason. That's all CFQUERYPARAM does - it creates bound parameters.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
This email has been processed by SmoothZap - www.smoothwall.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285976
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
