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
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!

Reply to this topic