Hi friends,

Here i've a problem in asp. When i am adding a record to database its adding it but when i refresh it its adding the same record again to databse. How to prevent adding record to database if user submits the page using refresh

Please help to overcome this problem

Thanking you in advance

__________________
B.V.Kumar

Take a look at this article:
http://www.4guysfromrolla.com/webtech/111500-1.shtml

Regards,

Gerhard Wentink

That is a handy article, but it doesn't address the underlying problem.

What I have done in the past is this:
Post your page to whatever page you wish to have handle the database update, but then on successful completion redirect to another page, or even to the same page, it doesn't matter. By redirecting, you are getting the browser away from a page that was posted to. You may need to "carry over" something, like a message indicating that the operation was completed, but this is much easier than trying to block all the different ways the user can go "back". They can refresh that "your record is updated" page over and over without affecting the actual db operation.

Peter
------------------------------------------------------
Work smarter, not harder.

Why don't you remove the Proxy and browser cacheing of that page. So whenever the user refreshes, it won't retain its old state.

The page will be rendered newly. So you will not get your problem.


Balakumar Vijayan
Sr. S/W Engr.
Trivandrum