This is not the only case. If you use pooled statements on the datasource (which is a default for CF) you can demonstrate another case:
Create a table. Select * from it in a CF template. Add a column to the table in the DB. Run the same template again. See the problem. On Thu, Jul 24, 2008 at 11:20 PM, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >>It shouldn't make a difference if the SELECT * is in a cfquery > > I see. > A very particular situation though. It will not prevent me from using > SELECT * when > I need all fields. This is more efficient than list all of them. > On the opposite, using SELECT * just to get a record count is the worse > case. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:309611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
