re: Multi page forms

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Buyens (news_at_interlacken.com)
Date: 04/12/04


Date: Mon, 12 Apr 2004 15:46:07 -0700


>-----Original Message-----
>Is there a way to have more than one page belong to the
>same form. For example: Personal info on first page,
>user clicks next, business info on second page. If this
>is some kind of add-in that I will have to purchase, I
>guess I'm looking for a resource for that also. Thanks...
>.

In a technical sense, a single HTML form can't span more
than one page. However, either of the following approaches
can create the same effect.

1. Include a key field, such as a userid, on each form.
   Then, whenever a visitor submits any form in the
   series, check to see if that userid already exists
   in a database. If so, update it. Otherwise, create it.
   When you create a record, set a status code field to
   some value that means "pending". When you update a
   record, check to see if the record is now complete.
   If it is, set the status code to "ready for processing."

2. Save all the submitted form fields in Session
   variables. (These are areas of memory that the server
   retains between successive requests from the same user.)
   Copy this information into the database only when the
   information is complete.

3. Save *all* the submitted values in hidden or visible
   form fields (depending on the current form). Add this
   information into the database only when the
   information is complete.

To achieve any of these results, you'll need to write some
server-side program code (i.e. ASP, ASP.NET, PHP, ...).

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------



Relevant Pages

  • re: front page 2000: METHOD.GET does not carry all of the text from the current
    ... Microsoft FrontPage MVP ... SQL update statement ... >updates that row in the database. ... >reduce the data in the form fields to a certain length. ...
    (microsoft.public.frontpage.programming)
  • Re: Database Wizard P*****G me off
    ... Microsoft Office FrontPage ... > In the SQL language, which the DRW uses to perform database operations, as ... Syntax error in UPDATE statement. ... >> One or more form fields were empty. ...
    (microsoft.public.frontpage.programming)
  • Re: Insert txt files into a form?
    ... I figured out a way to set up the data in word using form fields from my ... but each entry sets up on it's own "page." ... I am using a database program to maintain research articles records. ... word wher ethe form fields are lined up as a bibliography. ...
    (microsoft.public.word.docmanagement)
  • Re: Locking form
    ... you could have the data from your form fields ... uploaded to a database, ... >> original plus the pdf. ... >> This message is posted to a newsgroup. ...
    (microsoft.public.word.vba.general)
  • Re: Search an Access Database
    ... RJP wrote: ... > Source: Microsoft JET Database Engine ... > for all form fields that are used in the query. ... >>> Spider Web Woman Designs ...
    (microsoft.public.frontpage.programming)