<cfset CFUSION_DBCONNECTIONS_FLUSH()>
Connections Flushed.
OR (CF 4.5 and later):
<CFSET rc=cfusion_disable_dbconnections("cfmysource","1")> to disable a
specific datasource.
<CFSET rc=cfusion_disable_dbconnections("cfmysource","0")> will re-enable
it.
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-----Original Message-----
From: megan sherman [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 9:27 AM
To: CF-Talk
Subject: the dbl devil
Hi all,
I'm using Access for my database. Sometimes when I need to make changes
to the database on the server there is a .dbl file in the directory. I
can't delete it, and it won't let me upload the database. A couple days
ago someone on this list said to create a query calling a table that
doesn't exist. I did that. Got the error on the screen, but the devilish
dbl was still there. I talked to my cf host and he said, "Your code is
holding your database too long..put in your code a time to release the
database after so many minutes." Does anyone know what he was talking
about?
Also, thanks for your assistance on my syntax error when inserting
date. I was thrown off because cfinsert and cfupdate worked fine. But
all went awry when I tried to use insert in a query in a cfloop. So
changing the field name from "date" to "classdate" did the trick.
Thanks!
Megan
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
