Auto Refresh

mateenmohd · February 22nd, 2004, 02:39 AM

How can auto refresh the ASP page ?

update page code
----------------

contractno=Request.Form("contractno")
contname=Request.Form("contname")
pstatus=Request.Form("pstatus")

// connection string

usql1="update contracts set "
usql2="contractno='"& contractno &"',"
usql3="contname='"& contname &"',"
usql4="pstatus='"& pstatus &"' where rec_id='"& rec_id &"'"

usql=usql1+usql2+usql3+usql4

cn.Execute usql
if err.number=0 then
Response.Redirect("records_list.asp")
else
Response.write("Wong entry")
end if
%>

it received value from records_list.asp page, after update the record, it redirect to record_list.asp page
but after update the records it des not display updated value until and unless press refresh button, why ?

How can auto refresh the asp update page ?

Mateen

happygv · February 22nd, 2004, 02:56 AM

Mateen,

I am surprised, why you wanted to refresh the page again.

Response.Redirect("records_list.asp") should be enough to refresh the page. I wonder if something is wrong with your records_list.asp

May be seeing the code from records_list.asp would help.

Cheers

-Vijay G

Imar · February 22nd, 2004, 05:51 AM

The page is probably cached by the browser, so you're looking at an old version of it, from the browser's cache. Add the following code to the top of the page, to prevent caching:

Code:

<%
  Response.ExpiresAbsolute = #1/1/1980#
  Response.AddHeader "pragma", "no-cache"
  Response.AddHeader "cache-control", "private, no-cache, must-revalidate"
%>

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

mateenmohd · February 22nd, 2004, 06:44 AM

Thanks.

now there is no need to click the refresh button, it
refresh the page when it redirect to that page.

you like to inform me, it is due to old internet explorer or
old visual studio version ?
(I am using visual studio 6.0 and IE 6.0.2800.1106 windows xp)

regards.

Mateen

Quote:

quote:Originally posted by Imar
The page is probably cached by the browser, so you're looking at an old version of it, from the browser's cache. Add the following code to the top of the page, to prevent caching:

Code:

<%

Code:

  Response.ExpiresAbsolute = #1/1/1980#
  Response.AddHeader "pragma", "no-cache"
  Response.AddHeader "cache-control", "private, no-cache, must-revalidate"
%>

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

melvik · February 22nd, 2004, 07:20 AM

Simply use

Code:

<meta http-equiv="refresh" content="1">

within ur <head>.
or use

Code:

window.location.reload();

within ur JavaScript codes.
HTH.

Always:),
Hovik Melkomian.

Imar · February 22nd, 2004, 07:24 AM

No, it's because how Internet Explorer (and other browsers) work. They keep a copy of the page for quicker access when you return to the same page. Many pages are relatively static, and don't change(much) so there is no need to retrieve the latest version from the server every time you visit the page.

However, dynamic pages, like this one, need to be retrieved from the server every time. The code I showed makes sure that the browser sees the pages as outdated as soon as it loads it, so it will get a fresh copy when you rerequest it.

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.