dB Hyperlink ??? - Please Help.

dB Hyperlink ??? - Please Help. (Full Version)

All Forums >> [Web Development] >> ASP and Database

Message

WRXSTi -> 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 -> 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 -> 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 -> 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 -> 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.....

WRXSTi -> RE: dB Hyperlink ??? - Please Help. (2/8/2002 12:04:09)
I tried your previous two suggestions above and both had no affect on the results. My code wouldn't fit here are my links showing it. http://151.203.234.220:49775/outfront/dbSearch.txt http://151.203.234.220:49775/outfront/itemDetail.txt Click on the above link and do a view source will work. rgds, Me

Chameleon -> 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 -> RE: dB Hyperlink ??? - Please Help. (2/8/2002 12:48:02)
That worked !! Thank very much. Me

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.0625