Same record added to db after reload/refresh

[new2unix]

Hi,

My form calls a second asp page to update the database. In the second page, there is an IF... THEN statement:

IF NOT isempty( Request ( "Submit" )) THEN ...

to execute the "INSERT INTO" routine and display the "Thank you..." message. Problem was, I noticed, if I clicked reload/refresh, the same record will be added to the db again. Is there anyway I can clear out the "Submit" value after the 1st successful "INSERT INTO" routine?

Thanks

Mike

 

[foxbox]

after your INSERT instruction you put:

response.redirect "thanks.asp"
response.end

(this is just 1 idea to solve this)


br
Gerard