Refresh after posting a form

[jayapalchandran]

I am sending information through form variables into a database.
when i refresh the page the same values are getting into the database
what i want is after sending form variables it should be cleared in the buffer or whatever area it is stored temply. i want help. jayapalchandran

[lmf232s]

what i always do is a redirect back to the same page so that if you refresh the page, it is refreshing the page load instead of the Database update.

Example

set oRS1 = oConn.Execute(SQL)
Response.redirect "Back2theSamePage.asp?id=222&redirect=True"


You can pass variables in the query string if you need them else just a redirect should solve the problem.

[Bullschmidt]

Related links:

Classic ASP Design Tips - Post Back Page
http://www.bullschmidt.com/devtip-postbackpage.asp

Classic ASP Design Tips - Dependent Listboxes
http://www.bullschmidt.com/devtip-dependentlistboxes.asp

And www.asp101.com/samples has some good, short database examples.

[jayapalchandran]

people can use AJAX to send information to the server instead of submitting the page. i havent done this but this is the information i got for my problem stated above...

go to ajax page in w3schools. their tutorial is simple and easy... enjoy...

[jayapalchandran]

and then after a long time i accidentally i did a code which worked like the first reply and i am using it. so the best way is to redirect with a different query string.