That doesn't solve the problem though of the query remaing in CF space as he loops through it to perform his mass CFMAIL operation.
I must say I don't think this is possible in the CF realm. It's meant to be a high level langauge so that developers don't have to think about such things as memory, consequently they're forbidden from controlling memory. When I once asked in #coldfusion on EfNet about actually deleting the data stored in a variable I was told I need to take at least a beginner's programming course in college. Quick review of previous posts should assure anybody that I have at -least- that much knowledge. CF doesn't have a free() or delete, nor does it have malloc() or new or anythign resembling them apparently. I can't say this is a bad thing at all in a programing langauge really. All you can do is live with the results and hope the engine makes good use of it's memory. If you're using CF and you run out of memory: upgrade your RAM. Period. Don't count on fancy programming to help you out. In reality though, if this query is needed why would you even want to delete it before you're done with your template? Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512 Ph. 616.554.2700 x2009 Fx. 616.554.3331 Mo. 616.291.2612 On Thu, 1 Nov 2001, Rose, Israel wrote: > Create a storedproc that either takes the query name as an input parameter, > or knows the query name and performs the deletion. > > Israel Rose > > > -----Original Message----- > > From: Christian Watt [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, November 01, 2001 3:08 PM > > To: CF-Server > > Subject: Deleting a Query??? > > > > Does anyone know if there is a way to delete query results, before the > > page > > is done processing??? > > I have a couple of pages that compile info and send mass emails, but some > > of > > the queries are only needed for a short period, but (correct me if I am > > wrong) the results of those queries will stay in memory until the page is > > done. Well, when one of the results can easily have over 50,000 rows, > > that > > is a lot of memory that could be freed up and either speed up the other > > processes running, or allow more to be run simultaniously. Any answer or > > push in the right direction would be VERY much appreciated. > > > > Thank You, > > Christian Watt > > SkillPath Seminars > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
