Charlie Griefer wrote: > Not using SELECT * is more of a "best practices" kind of thing. > > When you use it, you're potentially pulling more information than you need, > which is inefficient.
It can also lead to very hard to debug errors. When "*" is used, the list of columns can become cached. If the database changes, this cache does not necessarily get updated. The code will then break because the list of columns it is trying to get does not match the database any more. Even if the CFML was not actually using the columns that where added or removed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309653 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
