Memory leak while performing standard select queries ina FOR loop

[eapostol]

Hi -

I was wondering if someone can help me out with this issue.

1. We are pulling information from a struct/object in order to construct
queries.
2. These queries are dynamically constructed within loops - a query would be
performed, a list of columns would be retrieved to be stored in a result
object, I would get a specific foreign key and use it to delivery another
query, get the new queries columns and values etc.
3. the queries are strings sent over to a method within the coldfusion
component.
4. The method actually performs the query and returns a query object for use.

The problems are:

1. The page executes fine the first time. In fact, it executes fine on average
two more times, for a total of three times.
2. On the fourth iteration, Windows Task Manager suddenly has a huge spike in
memory usage attributed to jrun.exe - at about 500 Megs, the dev system slows
to a crawl.
3. I have to restart the server in order for it to work.
4. (this code was also tested through Flash Remoting, and I got an out of
memory error through that)

The challenges:
1. There is nothing syntactically wrong with the code (it shows up with no
errors, in fact, as mentioned, it executes a few times as demonstrated with a
CFDUMP tag.
2. There is nothing syntactically wrong with the component that performs the
query and returns the query object (again, it executes and returns a query
object).
3. The debug window reports nothing wrong. 14 SELECT queries are executed in
total as a result of the loop - when the page works the first few times.

I even added a small pause in the code to see if a delay might resolve the
problem (it doesn't).
Anyone have any general causes that might result in this problem? I have done
the google search, and other than general server settings (which we have played
with), reviewing server logs (which in fact pointed to an out of memory error -
with 1 Gig of RAM running its hard to believe) and JRun suddenly "spiking" in
both memory and CPU utilization, the problem has become quite muddled.


thanks

[eapostol]

It appears to have been fixed. I converted most of the CFML code to
cfscript...and it works now?

strange...what does that say about CFML when I have to use actionscript like
syntax to get the job done at the end of the day?

:confused;