Hi All,

I have an ASP page where users submit a form. Once submited, a record will be created in a SQL database with firstname+lastname+time being the PRIMIARY Key. Here is the problem. Let say the user decided to make a change(after he clicked on the submit button). To do so, he click on the Browser's "BACK" button. Then he make his changes(WITHOUT doing a refresh first). After making the changes, he hit SUBMIT button. As you have guessed, the page get an error message: "Violation of PRIMARY KEY constraint." How can I fix this problem? I want to do something where when the user click on the back button, a message similar to: "This page has expired, please do a refresh...." Any other option is appreciated as well

Thank you.

Leon

You can fix this by clearing the history when user clicks on the back button using javascript.

Hi Santhi,

Thank you for the advice. Just how do I go about clearing the history with Javascript? Just a hint will be fine.

Thank you.

Leon

You have to use location.replace(url) or history.go(1) to navigate when the user clicks on Back button in the browser.This way user wont be able to see the entered page.
This way we can clear the history making history object stores only one entry.

I don't think you can track the back button click because neither the
history.go() nor history.back() event is fired on clicking the browser back button.
One solution i prefer is as soon the registration is done successfully you set some session variable and check for this session variable on top of all pages. If it is already set that means the user has already registered and tried to come on the page using back button. You can redirect him to some error page on this.

Regards,
Vinay

Leon,

I would say you add the

in the tag of the FORM page. This would not let him go back, when tried, would push him forward to the same page. And if at all he would like to make changes, he has to come from the beginning.

Hope that helps.
Cheers!



_________________________
- Vijay G
Strive for Perfection

Thank you all VERY MUCH for your help, and especially Vijay. It works!!! :-)
Thanks again.

Leon