PDA

Click to See Complete Forum and Search --> : refreshing table in an ASP page

shvonne
July 22nd, 1999, 04:20 AM
i plan to put a table on an asp page which will be publish in the internet... if there is any changes make to the table in the database by someone else from the other side while i'm viewing it, what should i do to make to refresh the table so that the data shown in it is the most updated one??

thanks for help... cheers!!!

shvonne ^o^
Iulian Iuga
July 22nd, 1999, 05:07 AM
Dear shvonne,

You know that the ASP files running on server side and the result is a HTML page!!! You interrogate database using the ASP build-in objects (Command, …), so you can refresh the information in HTML page only browse again the ASP file.
Important:
User one browse the ASP page, so him have the table information …
You change the information on database
User two browse the ASP page, so him have the new information

Your user has displayed the table (in HTML page) a longer time without changing the page?

If yes you can use that, on the user side script (the language is javascript):

function refreshpage()
{
window.navigate ("http://your_server/your_path/file.asp")
}

and

<BODY onload="setInterval ('refreshpage()',5000)">

You can use other time interval for refresh. (in my code 5000)
shvonne
July 22nd, 1999, 05:30 AM
hai Iulian..
thanks for the information...

do you means that user one have to refresh the page again in order to get the updated data?? will this degrade the database and network performance if done many times by many users? is it another way round to solve this problem???

oh ya, another thing is that how m'i going to raiseEvent to the page so that it will refresh again when some one update the data in the database?? is there other alternative besides setting time interval??

best regards,
shvonne