ASP - data review BEFORE posting to database

[Tracie]

Hi All
Am a newbie to ASP... I have built a form and the data submits to my Access
2000 database fine. However, my users want to view (preview) the data BEFORE
it gets submitted to the database. I have built another form that submits
the data to an html page for review... but I can't figure out how to get
the data from the second page (it is no longer in fields) to the database?

What am I missing, this must be fairly easy to do? Enter data in a form,
review the data and if correct, submit to database?

Please help... trying to go live with this application in three weeks and
I would like to have some hair left to pull out on the next application ;
)
Thanks in advance for your help... please be pretty specific, I am new as
this ASP stuff.... Tracie

[John Cantley]

do a

dim objItem
For each objItem in Request.Form
Response.Write "<input type="hidden" name=....
next

when you are coming into your review page. This will then give you all your
form variables.

John


"Tracie" <jacobstr@ci.colospgs.co.us> wrote in message
news:39ff0c4a$1@news.devx.com...
>
> Hi All
> Am a newbie to ASP... I have built a form and the data submits to my
Access
> 2000 database fine. However, my users want to view (preview) the data
BEFORE
> it gets submitted to the database. I have built another form that submits
> the data to an html page for review... but I can't figure out how to get
> the data from the second page (it is no longer in fields) to the database?
>
> What am I missing, this must be fairly easy to do? Enter data in a form,
> review the data and if correct, submit to database?
>
> Please help... trying to go live with this application in three weeks and
> I would like to have some hair left to pull out on the next application ;
> )
> Thanks in advance for your help... please be pretty specific, I am new as
> this ASP stuff.... Tracie

[Olaf]

Tracie,

Johns' solution would work if your review page would be another ASP page.
But since you mentioned that you will be using HTML, DHTML would be another
solution.

Olaf

"John Cantley" <jcstrider@hotmail.com> wrote:
>do a
>
>dim objItem
>For each objItem in Request.Form
> Response.Write "<input type="hidden" name=....
>next
>
>when you are coming into your review page. This will then give you all your
>form variables.
>
>John
>
>
>"Tracie" <jacobstr@ci.colospgs.co.us> wrote in message
>news:39ff0c4a$1@news.devx.com...
>>
>> Hi All
>> Am a newbie to ASP... I have built a form and the data submits to my
>Access
>> 2000 database fine. However, my users want to view (preview) the data
>BEFORE
>> it gets submitted to the database. I have built another form that submits
>> the data to an html page for review... but I can't figure out how to get
>> the data from the second page (it is no longer in fields) to the database?
>>
>> What am I missing, this must be fairly easy to do? Enter data in a form,
>> review the data and if correct, submit to database?
>>
>> Please help... trying to go live with this application in three weeks
and
>> I would like to have some hair left to pull out on the next application
;
>> )
>> Thanks in advance for your help... please be pretty specific, I am new
as
>> this ASP stuff.... Tracie
>
>

[Tracie]

John
T H A N K Y O U ! ! !
Took me a while to figure out exactly where the input type had to go... but
I've tested it and it works beautifully!!!
I have spent so much time trying to work this out and you had the answer
right away! I can't tell you how much I appreciate your help!!
Again, THANK YOU!!
Tracie




"John Cantley" <jcstrider@hotmail.com> wrote:
>do a
>
>dim objItem
>For each objItem in Request.Form
> Response.Write "<input type="hidden" name=....
>next
>
>when you are coming into your review page. This will then give you all your
>form variables.
>
>John
>
>
>"Tracie" <jacobstr@ci.colospgs.co.us> wrote in message
>news:39ff0c4a$1@news.devx.com...
>>
>> Hi All
>> Am a newbie to ASP... I have built a form and the data submits to my
>Access
>> 2000 database fine. However, my users want to view (preview) the data
>BEFORE
>> it gets submitted to the database. I have built another form that submits
>> the data to an html page for review... but I can't figure out how to get
>> the data from the second page (it is no longer in fields) to the database?
>>
>> What am I missing, this must be fairly easy to do? Enter data in a form,
>> review the data and if correct, submit to database?
>>
>> Please help... trying to go live with this application in three weeks
and
>> I would like to have some hair left to pull out on the next application
;
>> )
>> Thanks in advance for your help... please be pretty specific, I am new
as
>> this ASP stuff.... Tracie
>
>

[Alexander Prokopyev]

Hello,

Other solution is to use an array saved in Session variable.
like:

dim F, Dict()
redim Dict(Request.Form.Count-1,1)
dim I: I=0
for each F in Request.Form
Dict(I,0)=F
Dict(I,1)=Request.Form(F)
I=I+1
next
Session("FormData")=Dict

Alexander Prokopyev.
MVP for ASP
www.brainbench.com

"Tracie" <jacobstr@ci.colospgs.co.us> wrote in message
news:39ff0c4a$1@news.devx.com...
>
> Hi All
> Am a newbie to ASP... I have built a form and the data submits to my
Access
> 2000 database fine. However, my users want to view (preview) the data
BEFORE
> it gets submitted to the database. I have built another form that submits
> the data to an html page for review... but I can't figure out how to get
> the data from the second page (it is no longer in fields) to the database?
>
> What am I missing, this must be fairly easy to do? Enter data in a form,
> review the data and if correct, submit to database?
>
> Please help... trying to go live with this application in three weeks and
> I would like to have some hair left to pull out on the next application ;
> )
> Thanks in advance for your help... please be pretty specific, I am new as
> this ASP stuff.... Tracie