Russ/Kam, Thanks for the info. I'll take a look at our db connections and see if we cache them. Thanks again for the insight,
Phil >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224794 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
