Unwanted ReInserts on Browser Refresh w/ASP,SQL Server

I have an ASP script that takes information from an HTML form and inserts it into an SQL server database. Everytime a user refreshes the page, the date is inserted again. I could use a Session variable to temporarlily halt the inserts, but this would keep the user from going back to the form and entering more data and if the variable timed out the same problem would exist.Recommendations?
Who is Participating?
sybeConnect With a Mentor Commented:
Don't do any HTML output on the page that updates the database, but in stead, after updating, do a redirect to another page:

This page should just display stuff, no database inserts.
When the user presses reload, then just this page will be reloaded.
tgogliaAuthor Commented:
The problem with this solution is that I am actually using a stored porcedure that first inserts information into the database, then returns information about what was submitted to the user. I can't redirect the user to another page and still display the results of the insert from the ADO recordset
- store the returned data in a sessionvariable
- store the returned data into hidden fields of a form and an autosubmit of the form with javascript, then display the data
tgogliaAuthor Commented:
Thanks for your help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.