You could also ask CF not to cache connections in the datasource. There might also be a way to programmatically drop the db connections. We had a script back when we were on CF 4.5 that would flush the db connections... is there a similar one for CFMX?
-----Original Message----- From: Figy, Kam [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 5:43 PM To: CF-Talk Subject: RE: Database changes causes Component Errors CF (or some sort of execution plan CF creates) caches the database's structure. You'll have to restart CF for the changes to be picked up as far as I know. /k -----Original Message----- From: Phillip Duba [mailto:[EMAIL PROTECTED] Sent: Friday, November 18, 2005 12:50 PM To: CF-Talk Subject: Database changes causes Component Errors Hello All, This is the second time in the past month we have come across this issue. The scenario is I have a component which contains a number of queries against our database. Some of these queries have a table.* in them. It appears if we alter the tables with the .*s, ColdFusion throws an error stating invalid type or cast (basically, it expects a number but gets a string) in these queries. This only happens when a new column has been added to the tables in question. Any ideas on why this is occuring or how to prevent this (other try and eliminate the *s)? We are running in a clustered environment but nothing within the component is persisted. Thanks, Phil ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224701 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
