Clearing values from variable when form proccesses ??

Robin · Dec 11, 2003

Ok, I have a form that on clicking of the Update button first updates
the specific record in the db, then Inserts if the vMemo field is not
empty. The problem that I'm having is that After updating if you hit
the [F5] key (refresh) it inserts another record ...
I have tried:
1. Clearing the vMemo field after the insert is done (vMemo = "")
2. Setting the value on the form for this field to ""

Neither of these are working. It's not displaying it on the screen
but it is holding it in memory (I guess). Any way to clear this out
after update/insert????
Thanks for any suggestions!!

Ray at · Dec 11, 2003

Change your page logic:

form.htm: posts to page.asp
page.asp: Processes form submission and has NO html. Redirects to
thanks.htm
thanks.htm: <html>Your record was inserted</html>

Ray at work

Alexey V.Zelenin · Dec 11, 2003

Ray at said:
Change your page logic:

form.htm: posts to page.asp
page.asp: Processes form submission and has NO html. Redirects to
thanks.htm

thanks.htm: said:

Ok, I have a form that on clicking of the Update button first updates
the specific record in the db, then Inserts if the vMemo field is not
empty. The problem that I'm having is that After updating if you hit
the [F5] key (refresh) it inserts another record ...
I have tried:
1. Clearing the vMemo field after the insert is done (vMemo = "")
2. Setting the value on the form for this field to ""

Neither of these are working. It's not displaying it on the screen
but it is holding it in memory (I guess). Any way to clear this out
after update/insert????
Thanks for any suggestions!!

Click to expand...

I think you can avoid creating the "thanks.htm" page by using this
technology:

1. User is on the page "form.asp"
2. He fills the form and sends it
3. System checks if "vMemo" is not empty
4. If it is not empty - inserts value
5. System calls
Response.Redirect( "form.asp?updated=yes" )
6. Else (if "vMemo" is empty) System checks if Reqest("updated")="yes"
7. If it equals, show the thanking message
8. Show the form and whole page if needed

If user presses f5 at this time, he will recieve again the thanking
message, but nothing will be inserted into database again.

Digital Signature field form in PDF generated document from HTML	5	Nov 16, 2022
Why is updating in DELETE trigger delayed when fetching user?	1	Mar 25, 2023
GridView not populating, but not all the time, clearing cache fixe	2	Apr 22, 2010
newbie: inserting data into sql form writes only null values	3	Jan 31, 2007
Passing form reference as variable to function	4	Mar 30, 2010
Clearing the data....	7	Jul 29, 2004
Only one table shows up with the information	2	Mar 29, 2023
Form update inside loop	1	Jan 25, 2008

Clearing values from variable when form proccesses ??

Robin

Ray at

Alexey V.Zelenin

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads