I'm pretty sure that the only time the query is resident in memory is during
the initial request, unless you specify it to be cached or set to a session
variable. So I don't think that is going to get you anywhere. Although, it
might be a good idea to look into a way to make sure the odbc connection
doesn't persist beyond the initial database call. I'm not sure the best way
to do this. I know you can specify in CF admin not to maintain database
connections. You may also look into using
CFUSION_DISABLE_CONNECTIONS([DSN],1) to kill the connection.
Rick
-----Original Message-----
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 6:20 PM
To: CF-Talk
Subject: Getting Rid of a Query
I need to run a query to create a list via ValueList(). Afterwards I no
longer need the qeury itself. How can I get rid of it (deallocate the
memory used) and does this actuall free the memory immediately? If it
doesn't, I suppose there's no real point.
Jim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
