The database / ColdFusion might be caching the datatable structures. In the ColdFusion admin, tryin editing the datasource and unchecking the "maintain connection" box (advanced settings). Then re-run the page. If this works, then it was just a caching issue (go back in and re-check that box as it has performance implications).
If that does NOT work.... No idea. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Brent Shaub [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 17, 2007 9:05 AM To: CF-Talk Subject: A query errors referring to deleted columns yet it doesn't refer to them Hello All, I'm wondering if anyone else has bumped into this oddity. I had a table with 25 columns that I had an update query update most of the fields. I then took out those fields from the query, and then the database. Happens all the time, right? For some reason, whenever I run the query, it fails stating it cannot find the deleted columns **even though the columns do not appear in the code CF shows with the error**. I've trimmed down the update to be a single column and it still errors stating 'unknown column' for the ones I deleted. If I add the unused columns back in, the query processes so I have a workaround. I was just hoping to only have valid fields in the database and not some that are needed because of a ghost query reference. I recycled the CF service, rebooted, pulled the query out of a cfc and pasted into the file, and still the same error. Any ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:266738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
