Deanna, Not sure of a programatic way - but you can add spaces to the queries in question (alter the query) to get the new schema. See this blog entry and the comments below.
http://mkruger.cfwebtools.com/index.cfm?mode=alias&alias=dbschemaChange -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 10:20 AM To: CF-Talk Subject: Refreshing a datasource in CF Is there a programmatic way to somehow "refresh" a datasource in CF? I've noticed that, periodically, I'll have a datasource that won't recognize new objects for some period of time. I think it's a caching issue. (These are oracle datasources with CF 6.1 Enterprise, though I'm not positive which driver is being used.) We happen to have 2 datasources that point to the same Oracle box: one a generic name that works on dev-test-prod and points to the appropriate instance of Oracle based on which instance of CF we're on; and one that explicitly points to the dev-test-production instance. I typically use the generic one, so that no code needs to change between dev-test-prod. But, sometimes, when I upload a new app to production, CF insists the underlying Oracle objects don't exist. If I switch the code to use the explicit dsn, voila, all works. The next day I can usually come back and switch it back and it works with the generic one, which is what makes me think it's a caching issue of some sort. This is not the same thing as the select * issue with not recognizing new columns added, as in my case, it doesn't even recognize that the tables exist. Thanks for any insight. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239615 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
