Let me explain you the whoe situation and may be you can tell me a solution.
I have a CF form. When I submit this CF form to my other CF page I call a
CGI script using CFHTTP, the CGI script once receives my request it
acknowledge me that it has received and started the data insertion process.
So now control comes back to my CF Page, then my CF page has to search the
data which is being inserted by the cgi script in the background. It may
take some time for cgi script to complete the whole process. So my job is to
display the data till I find END line in my search for the data. In essence
cgi is inserting data and at the same time I am displaying the data on the
screen.
So when I do a cfquery I will only get the records which are inserted by
cgi, my problem is I have to keep looking till cgi is done inserting and
allways my last record will be a string called XXXX. Timer is just a addon
on so I just dont be in the recursive loop forever.
I was thinking of different ways may be arrays or dont know how to tackle
this one, any help is appreciated.
Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
"It's Not Creative if it doesn't Sell."
http://www.g3group.com <http://www.g3group.com>
-----Original Message-----
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 8:19 AM
To: CF-Talk
Subject: RE: recursive function using cfquery
Done it many times
Although the timer thing is something I've not had to do before
What's the issue you're having?
-----Original Message-----
From: Ketan Patel [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 8:19 AM
To: CF-Talk
Subject: recursive function using cfquery
Has anybody done a recursive function using cfquery results. I want to
recursively query the table till I get the results or the timer of 90
seconds is done. The only reason why I need to do that is because I have
one
more script running in the background which is inserting records in the
table and my job is to fetch records as it inserts and stop till I get
end
signal or its 90 seconds.
Ketan
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
