Forums
This topic is locked
Save Values into New Table Before Deleting
Posted 13 Aug 2003 07:17:20
1
has voted
13 Aug 2003 07:17:20 Cathy French posted:
I have a form that automatically populates after doing a search. Once the user sumbits this form (Form1) it saves the information into a new table. I then want to delete the information from the table.
If I redirect it to a delete page after submission that works, BUT the user can then hit The Back Button and resubmit the form. I end up with several copies of the same information saved into the new table and then not deleted from the old table.
Any ideas on how to solve this?
I tried:
<%
Response.Expires=-1000
Response.CacheControl="no-cache"
%>
But it does not work..maybe becasue the information is dnynamically input into the Forms.
If I abandon the session, then Form2 won't populate.
Running out of time and would really appreciate any suggestions.
Replies
Replied 13 Aug 2003 14:43:13
13 Aug 2003 14:43:13 Vince Baker replied:
Can you not add a status field or when the form page loads, it runs a query to checks to see if a record already exists....if so, redirect to an error page.
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
Replied 13 Aug 2003 20:10:14
13 Aug 2003 20:10:14 Cathy French replied:
I pretty new at this, any guidance on how I would add a Status Field?
Thanks!
Thanks!