I do not and never have.  Not against it, but just never saw the need.

----------------------------------------

From: "Dain Anderson" <da...@terradotta.com>
Sent: Tuesday, March 15, 2011 10:27 AM
To: "cf-talk" <cf-talk@houseoffusion.com>
Subject: Do people still name their UPDATE, INSERT & DELETE queries?

I may have missed conversation of this over the years, so I figured I 
would
ask.

What's the current "take" on this (old?) practice? If I have a CFC 
function
that deletes a record, and that CFC contains a single query, do you find 
it
necessary to scope that query with a name?

<cffunction name="DeleteMe">
<cfset var q = "" />
<cfquery datasource="#variables.ds#" name="q">
delete mah stuff...
</cfquery>
</cffunction>

I've been refactoring some CFCs and ran into some named deletions and
thought this seemed odd to name them -- thoughts?

-Dain

*Dain M. Anderson
*Lead Developer
Terra Dotta, LLC
501 W. Franklin Street, Suite 105
Chapel Hill, NC 27516
Phone/Fax: 877-DOTTA-77 (877-368-8277)
http://TerraDotta.com <http://terradotta.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343056
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to