On Fri, Mar 7, 2008 at 11:50 AM, Ali <[EMAIL PROTECTED]> wrote: > Just another question. Is it better to use SELECT * if I want to select all > the columns or better I write each as i did in the query of this post.
if you -really- need them all, then there's probably not quite as much wrong with SELECT *. however, i'd advocate still typing out the column names for 3 reasons: 1) makes the code more self-documenting 2) if the query were to change, and you ended up needing fewer columns, you could just comment out those that you no longer need 3) see #1 -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. "Arf," she said. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:300763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
