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:266737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
