Odd recordset problems...
Application -
A common spreadsheet is uploaded into a web interface which extracts all of the fields and saves the values to a SQL 2000 database.
Details -
There is a ridiculous number of fields across the 3 worksheets of the spreadsheet. Saving the data is not a problem.
Problem -
When attempting to display the information from the spreadsheets only the first 75% (an estimate) of the recordset is displayed.
Confusing part -
If I loop through all fields and write them to the page before the html starts all of the fields in the form are populated. If I do not write the fields and values to the screen before the HTML then 75% of the fields are populated.
Temp fix -
As a fix I just looped through the fields saving them to a string. I then wrote the string into a table with a display style of none so the browser is happy and the user doesn't see it. This works, but is a terrible work-around.
Any other suggestions?
chrishirst posted this at 08:12 — 10th August 2005.
He has: 379 posts
Joined: Apr 2005
sounds like the response buffer is the problem. have you tried a response.flush at the end of each iteration of the display loop?
artsapimp posted this at 13:12 — 10th August 2005.
They have: 330 posts
Joined: Apr 2000
I have not tried that. This app needs to go online today so I am unable to make any changes that might not work. I will try to remember to try this if I ever have this problem again.
Thanks.
Free Math Test
Fun Math Games
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.