Insert one record over multiple pages

[btn]

Hi - using ASP/Acsess/VBscript I want ot insert a record in the database, but
this must be done over several web pages (1-2-3) because there are many form
fields. Only one record. What is the best way to do this? Use the insert
record behaviour for the first page and then user update record with session
MM_username for 2 and 3 ? Thanx! Bjorn.

[Paul Whitham TMM]

There are two ways to do this.

1) You could pass the form values from page to page in hidden fields and
then write them all at the end, or
2) The method you described.

IMHO 2) is a better option in ASP as at least you have some of the
information stored should the person run into a problem.

If you wanted to give ASP.Net a try then you could split the form over
several panels (which appear like pages) and then do an insert at the end as
..net holds form values betweens calls on the server.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"btn" <webforumsuser@macromedia.com> wrote in message
news:d1dj0i$saj$1@forums.macromedia.com...

> Hi - using ASP/Acsess/VBscript I want ot insert a record in the database,

but

> this must be done over several web pages (1-2-3) because there are many

form

> fields. Only one record. What is the best way to do this? Use the

insert

> record behaviour for the first page and then user update record with

session

> MM_username for 2 and 3 ? Thanx! Bjorn.
>