homepage Welcome to WebmasterWorld Guest from 54.161.185.244
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
Multiple form pages
ggombar

10+ Year Member



 
Msg#: 2885 posted 2:31 pm on Jul 21, 2005 (gmt 0)

Hi

I have 6 different pages form1.asp, form2.asp, form3.asp and so on. Each one of them have one form having multiple fields. When I submit the form on form1.asp , it takes me to form2.asp where I use Request.form to collect the values and insert a record in one of my tables in database.

In form2.asp I have a form which also has lot of fields when submitted takes me to form3.asp and inserts a record in another table.

This whole process goes till all 6 forms are submitted and records are inserted in 6 dfferent tables. My problem is that if a user refreshes any page say form2.asp, it creates a duplicate record in table of the values entered in form1.asp. Plz suggest me the best way to avoid this issue.

Thanks

 

mrMister

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 2885 posted 2:55 pm on Jul 21, 2005 (gmt 0)

Create a unique identifier on form 1 and check to see if data has been entered in to the database for that unique identifier. If it has, then don't execute the INSERT statement.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved