Page doesn't load all recordsets. Need a ONE TIME page refresh on load...
Posted on 2009-04-03
Experts, I'm back again... I have over 1300 lines of code and posting it is going to bore you half to death. Here's the situation: I have a page that loads and not all the recordsets load the first time. I get an EOF or BOF error, "Sometimes". Then you refresh the page and the error goes away.
Here's the error:
ADODB.Field error 800a0bcd
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/webproject/project-dashboard.asp, line 1330
The problem isn't EOF or BOF because when I refresh the page, there's no error. It doesn't make sense. It happens only for some users and not others. I have totals that are coming in from the database and either I get the results from a previous project or all "0s" (Zeros). Then I refresh the page and all the totals are there. Bizzar.
To me, it doesn't make any sense why on a refresh (reload) the page retrieves the data fine but on first load it doesn't. I have the proper meta tags for PRAGMA No-Cache and the like so that's not the problem.
Trying a window.location.reload() firing this from the BODY ONLOAD event causes an infinite reloading loop. Not good.
So how do I cause a REFRESH ONLY ONCE when this page loads or am I looking at a bigger problem or something really simple? If you really want the code, I'll paste it... but believe me, it's over 1300 lines.