Naming all the columns also prevents issues with incorrect pooled statements being cached when you add a column to the DB.
-- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 4 October 2010 22:14, Michael Grant <[email protected]> wrote: > SOT: Point of note, regardless of how tedious this task may seem you should > always select only the fields you are using. Unless you know that you are > using all fields in a table and that the table columns will never change for > that table, you should define the fields in your select statement. It's not > only more streamlined, but it makes it easier for other devs to read and > understand your code. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
