using the inputted data from an INSERT form to populate the redirect page?

Report · Jun 14, 2006

I have an INSERT form (ASP/MSSQL), that takes a customers details and, when
submitted, re-directs to a page on which I'd like to show them their entered
details? What is the best way to achieve this?

What happens at the moment is that the recordset I have created, which is
populated by matching the e-mail address they've entered with the e-mail
address in their record in the database, returns a EOF/BOF suggesting the
record doesn't exist. Am I simply not giving it a chance to properly
insert the record, before calling the redirect page, or should this work?

Thanks.
Nath.

Report · Jun 14, 2006

How are you testing the value?. You cannot use request.form as the value in
the email field has been used during the insert postback. You need to assign
it to a session variable.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Nathon Jones" <sales@NOSHPAMtradmusic.com> wrote in message
news:e6p3vo$n55$1@forums.macromedia.com...
>I have an INSERT form (ASP/MSSQL), that takes a customers details and, when
>submitted, re-directs to a page on which I'd like to show them their
>entered details? What is the best way to achieve this?
>
> What happens at the moment is that the recordset I have created, which is
> populated by matching the e-mail address they've entered with the e-mail
> address in their record in the database, returns a EOF/BOF suggesting the
> record doesn't exist. Am I simply not giving it a chance to properly
> insert the record, before calling the redirect page, or should this work?
>
> Thanks.
> Nath.
>

Report · Jun 15, 2006

Hi Paul,

Yes, I was trying to do Request.Form on the redirect page recordset.
How do I create the session variable if I can't populate it with
Request.Form, or is this done on the INPUT form page?

Really appreciate the help, thanks.
Regards
Nath.

"Paul Whitham AdobeCommunityExpert" <design@valleybiz.net> wrote in message
news:e6qgu8$iuv$1@forums.macromedia.com...
> How are you testing the value?. You cannot use request.form as the value
> in the email field has been used during the insert postback. You need to
> assign it to a session variable.
>
> --
> Paul Whitham
> Certified Dreamweaver MX2004 Professional
> Adobe Community Expert - Dreamweaver
>
> Valleybiz Internet Design
> www.valleybiz.net
>
> "Nathon Jones" <sales@NOSHPAMtradmusic.com> wrote in message
> news:e6p3vo$n55$1@forums.macromedia.com...
>>I have an INSERT form (ASP/MSSQL), that takes a customers details and,
>>when submitted, re-directs to a page on which I'd like to show them their
>>entered details? What is the best way to achieve this?
>>
>> What happens at the moment is that the recordset I have created, which is
>> populated by matching the e-mail address they've entered with the e-mail
>> address in their record in the database, returns a EOF/BOF suggesting the
>> record doesn't exist. Am I simply not giving it a chance to properly
>> insert the record, before calling the redirect page, or should this work?
>>
>> Thanks.
>> Nath.
>>
>
>

Report · Jun 15, 2006

Nathan

As part of the insert action define something from the form that is likely
to be unique such as emailaddress, and assign it to a session variable like
this

<%
session("svemail")=request.form("emailfield")
%>

Then on your redirected page simply filter the records by the session
variable,
and select the order to be in DESC order.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Nathon Jones" <sales@NOSHPAMtradmusic.com> wrote in message
news:e6r786$fap$1@forums.macromedia.com...
> Hi Paul,
>
> Yes, I was trying to do Request.Form on the redirect page recordset.
> How do I create the session variable if I can't populate it with
> Request.Form, or is this done on the INPUT form page?
>
> Really appreciate the help, thanks.
> Regards
> Nath.
>
> "Paul Whitham AdobeCommunityExpert" <design@valleybiz.net> wrote in
> message news:e6qgu8$iuv$1@forums.macromedia.com...
>> How are you testing the value?. You cannot use request.form as the value
>> in the email field has been used during the insert postback. You need to
>> assign it to a session variable.
>>
>> --
>> Paul Whitham
>> Certified Dreamweaver MX2004 Professional
>> Adobe Community Expert - Dreamweaver
>>
>> Valleybiz Internet Design
>> www.valleybiz.net
>>
>> "Nathon Jones" <sales@NOSHPAMtradmusic.com> wrote in message
>> news:e6p3vo$n55$1@forums.macromedia.com...
>>>I have an INSERT form (ASP/MSSQL), that takes a customers details and,
>>>when submitted, re-directs to a page on which I'd like to show them their
>>>entered details? What is the best way to achieve this?
>>>
>>> What happens at the moment is that the recordset I have created, which
>>> is populated by matching the e-mail address they've entered with the
>>> e-mail address in their record in the database, returns a EOF/BOF
>>> suggesting the record doesn't exist. Am I simply not giving it a
>>> chance to properly insert the record, before calling the redirect page,
>>> or should this work?
>>>
>>> Thanks.
>>> Nath.
>>>
>>
>>
>
>