Snake wrote: > > I modify my SQL database, add some new tables or columns to an existing > table, but CF cannot find them. > I have to restart CF before it can see the changes I have made. Sometimes > even restarting CF doesn't fix it. > The queries themselves are not being cached, as they pickup new data added > to existing tables. > This is not specific to my dev server either, I have experienced this on > multiple servers. > > Very weird. > > Anyone ever found the cause for this?
Execution plan caching from prepared statements (cfqueryparam). To flush the cache it should be enough to tear down and reopen all the connections between CF and the database. In the CF administrator, disable the datasource and then enable it again. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
