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"
rs("Link_Name"
EG:
----------------------------------------
< a_href="< %=rs("link_url"
----------------------------------------
Result:
< a_href="www.yahoo.co.uk">Yahoo: My-Link-Description< / a >
OR:
----------------------------------------
< a_href="www.mysite.com/< %=rs("link_url"
----------------------------------------
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