I'm 100% with you guys on this as well. Replacing the hundreds of "select *" from all the existing code here is one of my seemingly never ending tasks. I should have addressed that first before attempting to add anything else to the mix.
I'm done installing my Windows updates for the evening, so I'll tackle this again in the morning. Thanks for the help! Debbie -----Original Message----- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, February 01, 2011 5:41 PM To: cf-talk Subject: Re: SQL query question > > The evil of using * in SELECT clauses. > I'm with Ian on this 100%. Often times developers think that using * will be faster, and easier and allow more flexibility. However that couldn't be further from the truth as you are seeing now. Take Ian's advice and define each column you want from your query. The added bonus is that there's no extra overhead associated with returning columns you aren't using. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
