Don't do that. Are you using cfqueryparam? Change the structure of the query by adding AND 1 = 1, this will use a new exec plan and the old column won't be referenced. You may also get away with reformatting the SQL.
Adrian -----Original Message----- From: Brent Shaub [mailto:[EMAIL PROTECTED] Sent: 17 January 2007 18:46 To: CF-Talk Subject: Re: A query errors referring to deleted columns yet it doesn't refer to them Yep, it's the right datasource. I'll just use the workaround of having the fields there and not use them. I just hope this issue isn't the tip of some greater iceburg. >Did you double check your data source? Perhaps you are calling an >outdated database?? > >Other than that, I am out of suggestions. Good luck! > > >..................... >Ben Nadel >Certified Advanced ColdFusion MX7 Developer >www.bennadel.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
