Code Bank
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingCode Bank

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old October 6th, 2004, 07:14 PM
sk8ter04 sk8ter04 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: May 2004
Posts: 22 sk8ter04 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 40 m 40 sec
Reputation Power: 0
Question multipage submit fuction

hello all i would like to know some code for multi page add fuction i
have 5 pages each have different outlines on them my first page adds
the company details eg: business name and category this data needs to be saved then continue on to page 2
second page adds contact details eg: contact name, phone, mobile, fax and email this data needs to be save and continue on to page 3
third page adds business details eg: address, suburb, post code, web, hours, short description, and full description data needs to be saved and continue on to page 4
and the fourth page adds 4 pictures, all these pages are link to eachother when clicking a next button. When i click the submit button on page 4 i want it to get all the save data from the previous pages and add it all to a database so if anyone could
show me some code that will allow me to do this i will be greatful for the help

thank you

Reply With Quote
  #2  
Old October 6th, 2004, 08:41 PM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
 
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,770 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 7 h 8 m 6 sec
Reputation Power: 469
Why not just do this.
Page 1 save the data to the database, retrieving the new recordID after the insert is performed, by executing a SELECT @@Identity statement, which returns the newly created recordID, when the data is inserted.

Page 2 - 4, just update the database, with the data. Now that you have the recordID for that particular record, you can just run UPDATE statements to add the data to the database.

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingCode Bank > multipage submit fuction


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT