Both methods are "commonly" used.
Another method used is to have multiple pages like you've mentioned
but save all the data into a session (of just pass it from page to
page) until all 3 pages are complete and then write all the data at
once
The question to ask yourself is, do you want just partial data, an
incomplete form, to be in your database/table. If you don't, then
method 1 or the method I just mentioned is the way to go. Otherwise
you'll have incomplete data in your dataset.
Surveys do both of any/all 3 of these methods. Of course, with ajax
now, I'm seeing more written to the database while a user is inputing
their data and then the web application has to remove, at some point,
incomplete data.
Good Luck!
Have to develop form with over 100 input fields plus 40 different
drop downs. Seeking advice on technique to use. Thinking about
single form where user has to use the power bar to move deeper into
the form. This has benefit that every thing is written to the
database at one time, but the draw back is the user frustration in
entering so much data at one time. Alternate thoughts are breaking
it down into 2 or 3 separate pages with each page being written to
the data base. First page does a insert to create the row, then
following pages do updates to complete populating the row with data.
Has anyone done anything like this or have seen this done before.
What advice can you offer.
Where to look for examples.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
--------------------------------------------------------------------------------
/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.fmsystems.biz);
/Lasso Partner Association Member ID #LPA135259
(www.omnipilot.com/www.lassopartner.com);
--------------------------------------------------------------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
