Preserving Access Hyperlinks with the DRW

J

jerod

I have a databse which contains a hyperlink column, which I have made
searchable with the DRW.

Now what I would like to do is have FrontPage pull the data from the
hyerplinked column in Access, display the information in that field and
preserve the hyperlink that I have established in Access.

Example:

Access has entry "Glue" hyperlinked to elmers.com (which works fine when
clicked)
User searches for "Glue" on the website
Results pop up on the page, with result "Glue" hyperlinked.
User clicks on "Glue", is taken to elmers.com

I would like to avoid adding a column in Access that spells out the
hyperlinks, but if I'm told here that what I'm trying to do is not possible,
then so be it.

Thank you.
 
J

jerod

After further reasearch, I have found a workaround as "MS Access supports the
hyperlink data type in its databases. However, these fields are not displayed
correctly and they do not work as hyperlinks on Web pages without doing some
editing."

THe workaround is found here: http://www.meg.uct.ac.za/downloads/Web/asp.htm

So I created a custom query with

SELECT URL, Description, '<a href="' & URL & '"> ' & Description & '</a>' AS
Hyperlink
FROM WebLinks; I was able to generate a "working" link in the results page.

However, my problem now is that I do not know how to link it properly...for
example...I've tried testing a link to google.ca and the url it is linking to
is
http://devsite5/whs_test/whs_interface/Results/editor/www.google.ca
(relative).

I'm hoping someone who reads this can tell me where I can change it to
simply display www.google.ca.

Thank you
 
Top