|
| |
|
|
WRXSTi
Posts: 30
Joined: 2/7/2002
From: MA USA
Status: offline
 |
dB Hyperlink ??? - Please Help. - 2/7/2002 20:36:46
Hi... I'm new at .asp and am using FrontPage 2002. I've got a DRW form and a custom query on the fields item #, subject, email... etc.
On item # I have a hyperlink to itemDetail.asp and want that item shown in details on a seporate page. I need to know how to pass the item # selected so that the row in the dB email, subject, description... etc, are displayed as well and corresponds to the item # selected from the hyperlink.
My sample is located here:
http://test.meat-heads.com
All help is apperciated.
rgds,
Jim
wrxsti03@hotmail.com
Me
|
|
|
|
rdouglass
Posts: 9265
From: Biddeford, ME USA
Status: offline
|
RE: dB Hyperlink ??? - Please Help. - 2/7/2002 21:29:12
Couldn't get to your link, but if you're using straight DRW, you can select the field and make it a link. You can setup the link to pass your parameter by checking this link:
http://www.outfront.net/spooky/hyper_param.htm
That should get you to pass it. Now to pick it up, follow this link:
http://www.outfront.net/spooky/search_hyper.htm
These are quite good instructions if you follow them carefully, but if you get stuck, repost. Hope it helps...
| |
|
|
|
SerenityNet
Posts: 1368
Joined: 6/12/2001
From: Allen, TX, USA
Status: offline
|
RE: dB Hyperlink ??? - Please Help. - 2/7/2002 21:30:48
Try the following:
itemDetail.asp?ITEM=<%=FP_FieldURL(fp_rs,"ITEM")%>&EMail=<%=FP_FieldURL(fp_rs,"EMail")%>&subject=<%=FP_FieldURL(fp_rs,"subject")%>&description=<%=FP_FieldURL(fp_rs,"desription")%>&ETC=<%=FP_FieldURL(fp_rs,"ETC")%>
That is, go to your hyperlink properties, add the destination, then click on the parameters button to add the other values you want to post to the next page.
Someone here referred me to the FP tutorials at http://www.sitebuilder.ws/frontpage/tutorials/ If you are using an Access DB then just what you are asking is covered in detail there.
I hope this helps,
Andrew
webmaster@serenitynet.net - But the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness, and self-control..." Gal. 5:22
| |
|
|
|
WRXSTi
Posts: 30
Joined: 2/7/2002
From: MA USA
Status: offline
|
RE: dB Hyperlink ??? - Please Help. - 2/8/2002 10:49:18
Sorry for the bad link my system booted to Linux and not W2K Server.
If you see my example here:
http://test.meat-heads.com
When Item # 3 is selected Item # 2 is returned. I need to know the commads which goes here:
http://image.meat-heads.com so I can have the correct item record returned.
I looked at Spookies FAQ and tip sugested above but they didn't entirly solve my issue.
Thanks !!
Me
| |
|
|
|
rdouglass
Posts: 9265
From: Biddeford, ME USA
Status: offline
|
RE: dB Hyperlink ??? - Please Help. - 2/8/2002 11:09:18
Based on your screenshot, I think it should be something like:
itemDetail.asp?ID=<%=FP_FieldVal(fp_rs,"ID")%>
or whatever your fieldname is. Does that make sense??? See, what you're trying to do is have FP place the ID as the querystring. In order to do that, you have to use some VBScript (at least in your scenario). We're just placing the FP field there. You may even want to 'hard code' it first to be sure everything else works. For instance, try just putting:
itemDetail.asp?ID=3
in your hyperlink address def to see if that works. Then replace the hard code value with the FP value.
If you are still stuck, maybe you can post the actual ASP / HTML code and we can work from there.....
| |
|
|
|
Chameleon
Posts: 84
From: Springfield, MO
Status: offline
|
RE: dB Hyperlink ??? - Please Help. - 2/8/2002 12:20:19
It looks to me like you are passing the parameter to the page correctly but you don't have the DRW on the detail page looking for a parameter. Here's what you need to do.
On the item detail page open your database results properties and on step 3 click more options. Then click criteria, click add and choose ID. The fileds should be as follows...
Field Name - ID
Comparison - Equals
Value - ID
Click OK 3 times then click next until you get to step 5 of the DRW. Uncheck Add search form and click finish. that should fix the problem.
| |
|
|
|
WRXSTi
Posts: 30
Joined: 2/7/2002
From: MA USA
Status: offline
|
RE: dB Hyperlink ??? - Please Help. - 2/8/2002 12:48:02
That worked !!
Thank very much.
Me
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
