This may have been answered by now but here my 2c worth.
The bad query route has never worked for me. Comments last year on this
board lead to recognition that the .ldb file is the culprit and the only way
to get rid of that is to flush the DB connection. This works both locally
and remotely, be aware that ALL connections to the DB are flushed so any
users will be inconvenienced. Then rename the old DB and upload the new one
before a new connection is made. Working Code follows, I put this page on my
sites specifically for this purpose
Richard Kern
------------------
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>DB Connection Flush</title>
</head>
<body>
<cfoutput>#cfusion_dbconnections_flush()#</cfoutput>
DB flushed!!
</center>
</body>
</html>
this also works
<cfset CFUSION_DBCONNECTIONS_FLUSH()>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
