By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

Looking into a recordset until it returns a result

P: n/a
I currently connect to two servers. One is IIS, that runs my asp and
sql server, and the other is an AS400, that also cranks out data.
Sometimes I have to wait for data I submit to the as400 to finish
being processed before it kicks back the recordset. If my page runs
before the as400 is done, it crashes. To put a delay into the page to
give the as400 plenty of time to finish, I've been placing a simple
loop for x = 1 to 1000000000 before proceeding to trying to display
the recordset.

What I'd like to do is find a loop that will keep looping if the
recordset is not populated, and then display once it is. Does anyone
know how I would do this?

Thanks,

Bill
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
How do you "submit" data to the AS400? Doesn't sound as though you are just
querying the system...

tim

"Bill" <bi***********@gospellight.com> wrote in message
news:8d**************************@posting.google.c om...
I currently connect to two servers. One is IIS, that runs my asp and
sql server, and the other is an AS400, that also cranks out data.
Sometimes I have to wait for data I submit to the as400 to finish
being processed before it kicks back the recordset. If my page runs
before the as400 is done, it crashes. To put a delay into the page to
give the as400 plenty of time to finish, I've been placing a simple
loop for x = 1 to 1000000000 before proceeding to trying to display
the recordset.

What I'd like to do is find a loop that will keep looping if the
recordset is not populated, and then display once it is. Does anyone
know how I would do this?

Thanks,

Bill

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.