Confirmation page: I need to get the Record ID back to conf page.

[sandrocket]

How can I get the MS Access Record ID back to my confirmation page? The
Record ID is the autonumber unique identifier for the record just added to
the DB by the SUBMIT. I can get all of my submitted fields on my
confirmation for but not the record where the information resides.

Also, I want to inject that Record ID into a hidden field for paypal so I
have a direct link to the form data submitted.

 

[Kathleen Anderson [MVP - FrontPage]]

http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Autonumber

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[sandrocket]

Kathleen, Thank you for the perfect assistance. I successfully added the MS
Access record ID to my confirmation page with your awsome help. With the
addition of the code tip ID is now appearing in my FrontPage 2003 as
Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It is
now appearing on my confirmation form.

Now, I want to pass that same record ID into a PayPal hidden field which are
controlled by web bots. I need to set the item_number to the MS Access record
ID

The hidden field code looks like this:
<input type="hidden" name="item_number" value=???>

I need the code to insert the Record ID into the hidden field. When I am in
the code view, the Insert --> Web Component is muted out, so I cannot use it
and the ID is under control of the web bot. Logically it may look like this.

<input type="hidden" name="item_number" value=fp_rs(0)>

Paul

 

[Stefan B Rusynko]

Using that same example it would be
<input type="hidden" name="item_number" value="<%=FP_SavedFields.Item("ID")%>">


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Kathleen, Thank you for the perfect assistance. I successfully added the MS
| Access record ID to my confirmation page with your awsome help. With the
| addition of the code tip ID is now appearing in my FrontPage 2003 as
| Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It is
| now appearing on my confirmation form.
|
| Now, I want to pass that same record ID into a PayPal hidden field which are
| controlled by web bots. I need to set the item_number to the MS Access record
| ID
|
| The hidden field code looks like this:
| <input type="hidden" name="item_number" value=???>
|
| I need the code to insert the Record ID into the hidden field. When I am in
| the code view, the Insert --> Web Component is muted out, so I cannot use it
| and the ID is under control of the web bot. Logically it may look like this.
|
| <input type="hidden" name="item_number" value=fp_rs(0)>
|
| Paul
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Autonumber
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| >
| >
| > | > > How can I get the MS Access Record ID back to my confirmation page? The
| > > Record ID is the autonumber unique identifier for the record just added to
| > > the DB by the SUBMIT. I can get all of my submitted fields on my
| > > confirmation for but not the record where the information resides.
| > >
| > > Also, I want to inject that Record ID into a hidden field for paypal so I
| > > have a direct link to the form data submitted.
| >
| >
| >

 

[sandrocket]

Excellent support! Thank you!

Kathleen, Thank you for the perfect assistance. I successfully added the MS
Access record ID to my confirmation page with your awsome help. With the
addition of the code tip ID is now appearing in my FrontPage 2003 as
Insert->Web Component --> Advanced Controls --> Confirmation -> ID. It is
now appearing on my confirmation form.

Now, I want to pass that same record ID into a PayPal hidden field which are
controlled by web bots. I need to set the item_number to the MS Access record
ID

The hidden field code looks like this:
<input type="hidden" name="item_number" value=???>

I need the code to insert the Record ID into the hidden field. When I am in
the code view, the Insert --> Web Component is muted out, so I cannot use it
and the ID is under control of the web bot. Logically it may look like this.

<input type="hidden" name="item_number" value=fp_rs(0)>

Paul

 

[sandrocket]

Thank you! Yes, this worked! I love this ! -- Paul

 

[sandrocket]

In Frontpage I list a set of records using the DRW. I want to drill down
using the Record ID into the details of the record using the Record ID.

For example I may show ID and Name and I want to hyperlink using the ID to
show more specific fields in the record when I pick on the ID hyperlink but I
dont know how to do the drill down.

 

[Kathleen Anderson [MVP - FrontPage]]

http://www.spiderwebwoman.com/tutorials/picklist.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[sandrocket]

Kathleen, That was the fix; it is working. Thank you !