Forums
This topic is locked
dynamic Access table/links
Posted 19 Sep 2002 17:04:01
1
has voted
19 Sep 2002 17:04:01 Gary Holabird posted:
I am ready to give up.All I want to do is create a web page which dynamically links to an MS
Access database (very simple, 1 table). This page's fields would be dynamic links to open HTML pages. No detail page (the HTML pages would be the detail pages. Just a "master" page. Is this such an impossible idea, or am I having continuous BRAIN FARTS? I am using DW MX,.asp.
When I create the Access fields as hypertext, those fields appear on the .asp table with the URL in the field, and there is no link.
Thanks,
Gary
Replies
Replied 24 Sep 2002 16:14:27
24 Sep 2002 16:14:27 Stuart Harland replied:
If your field data for the link is something like 'test.html' or 'www.yahoo.co.uk' then just have the data type set as varchar/ text rather than URL/ Hyperlink.
This where you're displaying your links use code like this:
rs("link_url" would be the link field in your database
rs("Link_Name" would be the name field in your database
EG:
----------------------------------------
< a_href="< %=rs("link_url"% >">< %rs("Link_Name"% >< / a>
----------------------------------------
Result:
< a_href="www.yahoo.co.uk">Yahoo: My-Link-Description< / a >
OR:
----------------------------------------
< a_href="www.mysite.com/< %=rs("link_url"% >">< %rs("Link_Name"% >< / a >
----------------------------------------
Result:
< a_href="www.mysite.com/test.html">My Test Link< / a >
hope this helps a bit
********************
wheatNOTmeat
This where you're displaying your links use code like this:
rs("link_url" would be the link field in your database
rs("Link_Name" would be the name field in your database
EG:
----------------------------------------
< a_href="< %=rs("link_url"% >">< %rs("Link_Name"% >< / a>
----------------------------------------
Result:
< a_href="www.yahoo.co.uk">Yahoo: My-Link-Description< / a >
OR:
----------------------------------------
< a_href="www.mysite.com/< %=rs("link_url"% >">< %rs("Link_Name"% >< / a >
----------------------------------------
Result:
< a_href="www.mysite.com/test.html">My Test Link< / a >
hope this helps a bit
********************
wheatNOTmeat
Replied 25 Sep 2002 15:39:17
25 Sep 2002 15:39:17 Gary Holabird replied:
Thanks very much. I'll have to try that. I had forgotten about varchar.
Thanks again,
Gary
Thanks again,
Gary