Thanks. I'm using 4.0 and cfusion_disable_dbconnections is 4.5x . I was looking for a temporary solutions, but I'm just going to upgrade to 5.0. It's the easiest thing, plus I get all the cool new features.
Thanks for your help. Chuck -----Original Message----- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 11:55 AM To: CF-Talk Subject: Re: cfusion_dbconnections_flush() At 10:24 AM 12/14/2001 -0500, you wrote: >I have a question about using #cfusion_dbconnections_flush()#. > >The problem we are having is with an excel odbc data source. If we modify >the spreadsheet, the changes are not reflected after the page is reloaded. >In the ODBC settings, we have unchecked "maintain database connections". We >are not caching the query either. > >We are still running CF4 (not for long, though). Now for the question.... > >Will using #cfusion_dbconnections_flush()# clear all cached queries >including those that have specified a cached within in our <cfquery> tag? I'm pretty sure that cfusion_dbconnections_flush is a tag completely separate from cached queries. The two have no relation. It merely releases the data connection. >If so, is there a way to release the excel odbc connection without affecting >other data sources? Yes. You can check the FAQ: [snip] <CFSET rc=cfusion_disable_dbconnections("cfmysource","1")> to disable a specific datasource, and <CFSET rc=cfusion_disable_dbconnections("cfmysource","0")> to re-enable it. [endsnip] I believe this would accomplish the task. I've used it for excel sheets before without problems. -- Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946 -- DotComIt: Database Driven Web Data My Book: Instant ColdFusion 5 | http://www.instantcoldfusion.com My New Book: ColdFusion: A Beginner's Guide due out next February -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- You never knew, the things your beauty made me want to do ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists