CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Forms

Print topic Send  topic

Author Message
maya
Posted: 10/30/2003, 10:04 PM

Any Help Please
I have a very long survey form (3 sections)and I want the user to be able to enter information (section 1) then save; continue to fill out form (save section 2) then to continue to fill out form then (save) Submit.

Environment Windows 98, MS Access, win2000
Product CodeCharge Studio 1.0.7
Programming Language ASP/VBScript w/Templates
ryan
Posted: 10/31/2003, 3:26 PM

Maya,

U'r question is similar to the one I previously posted. It's not an easy task though but....here's a guide (of course this is not the best solution but works good enough for me :)

Determine the form elemens/database fields to be saved on each sections!!!

basically I can visualize ur Survey table as 'something' like

Survey
--------------
ID----Survey----Desc---fld1---fld2---fld3----item1----item2----item3
1-----hello-----hello--1------2------3-------i1-------i2-------i3
2-----hello-----hello--4------5------6-------i4-------i5-------i6
3-----hello-----hello--7------8------9-------i7-------i8-------i9
4-----hello-----hello--10-----11-----12------i10------i11------i12
5-----hello-----hello--13-----14-----15------i14------i15------i16
6-----hello-----hello--16-----17-----18------i16------i17-------i18

The working algo I think would be

----------
Section 1
----------

Survey--------Desc------

'save these fields temporarily before going to Section 2

----------
Section 2
----------

fld1----------fld2------fld3

'save Section 1 & Section 2 fields temporarily before going to Section 3
'if user hits back, must be able to do update on Section 1
'if user cancels then don't proceed saving

----------
Section 3
----------

item1---------item2-----item3

'save Section 1 & Section 2 fields temporarily before hitting the final Submit
'if user hits back, must be able to do update on Section 1 & Section 2
'if user cancels then don't proceed saving
'if final Submit button is clicked save all fields (section 1, 2, 3)

I hope this will be a (not good enough) idea, now apply it...it's tedious though to save 255 fields you can either break down your tables to one is to one relationship (more db tables) or this would open your analytical mind to something more efficient :)

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.