Looking into a recordset until it returns a result

Discussion in 'ASP General' started by Bill, Jul 2, 2003.

  1. Bill

    Bill Guest

    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
     
    Bill, Jul 2, 2003
    #1
    1. Advertisements

  2. Bill

    Tim Williams Guest

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

    tim
     
    Tim Williams, Jul 2, 2003
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.