re: Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Jason Fisher
I do not and never have. Not against it, but just never saw the need. From: "Dain Anderson" Sent: Tuesday, March 15, 2011 10:27 AM To: "cf-talk" Subject: Do people still name their UPDATE, INSERT & DELETE queries? I may hav

Re: Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Dave Watts
> 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? It's neit

Re: Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Dave Watts
> I would even go so far as to recommend you delete it. Less code means less > bugs. The converse of this is, fewer changes to existing code means fewer bugs. There's no reason to waste time making trivial changes to existing code. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http

Re: Do people still name their UPDATE, INSERT & DELETE queries? [spamtrap heur]

2011-03-15 Thread Paul Hastings
On 3/15/2011 9:34 PM, Raymond Camden wrote: > I don't bother. Is it worthwhile to go through code and change it - > not imho. (Unless of course you forgot to varscope it.) but builder complains though. and we must do what builder says, right ;-) ~~

Re: Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Dain Anderson
Agreed, we do this as well. I'm more or less concerned with a more "in general," as a concept. It sounds like it's unnecessary and safe to remove. Thanks for everyone's help. -Dain On Tue, Mar 15, 2011 at 10:40 AM, Phillip Duba wrote: > > I do purely for debugging purposes. This way I can du

Re: Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Phillip Duba
I do purely for debugging purposes. This way I can dump the resultset, with the new features in 8 and 9, and see exactly what is going on with the query in the form of parameters, generated SQL, etc., Phil On Tue, Mar 15, 2011 at 10:26 AM, Dain Anderson wrote: > > I may have missed conversation

Re: Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Casey Dougall
On Tue, Mar 15, 2011 at 10:26 AM, Dain Anderson wrote: > > 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

Re: Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Nathan Strutz
If you aren't using any kind of returned data from a query, don't worry about giving the cfquery tag a name attribute. It's a few extra bytes you can save on your fingers. I would even go so far as to recommend you delete it. Less code means less bugs. nathan strutz [http://www.dopefly.com/] [htt

Re: Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Raymond Camden
I don't bother. Is it worthwhile to go through code and change it - not imho. (Unless of course you forgot to varscope it.) On Tue, Mar 15, 2011 at 9:26 AM, Dain Anderson wrote: > > I may have missed conversation of this over the years, so I figured I would > ask. > > What's the current "take"

Do people still name their UPDATE, INSERT & DELETE queries?

2011-03-15 Thread Dain Anderson
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? d