Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Big form problem
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Rob.B
New Member

Netherlands
93 Posts

Posted - 13 September 2003 :  11:31:21  Show Profile  Visit Rob.B's Homepage
Here's the situation:

I have 6 forms. Every single form is a seperate file (form 1, form 2, form 3 till form 6) When the first form has been filled in the visitor can go to form 2 etc. etc.

Whats the best way to save all the data, entered by users, in an access database?

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 13 September 2003 :  11:37:52  Show Profile
when each form is submitted, grab the info for the form fields and construct and INSERT sql statement to save to your database.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

Rob.B
New Member

Netherlands
93 Posts

Posted - 13 September 2003 :  11:43:09  Show Profile  Visit Rob.B's Homepage
quote:
Originally posted by Nikkol

when each form is submitted, grab the info for the form fields and construct and INSERT sql statement to save to your database.



That's possible but each form contains about 15 till 20 input fields.
At the end I 'll have about 108 request.forms and a huge INSERT sql statement... Is it the only and best option?
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 13 September 2003 :  11:58:36  Show Profile
you are going to have to use request.form in some fashion or else how do you expect to send form results to a database or any other thing?

here's a hint however: check out how snitz code updates the config variables on the admin pages by looping through the form fields.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07