Database Discussion - database hyperlinks

Print Page | Close Window

database hyperlinks

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13945
Printed Date: 30 March 2026 at 4:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: database hyperlinks

Posted By: Dekieon
Subject: database hyperlinks
Date Posted: 22 February 2005 at 9:09am

In an access db, i have created a table that contains a field which is a hyperlink type. The hyperlink points to a web address.

when I run my asp code, the hyperlink doesn't work. I displayed the contents of the hyperlink variable with...

response.write var_URL

and the results are

#http://www.somewhere.com/#

And where are those #'s coming from? I'm not sure, but they are messing me up.

What are they, and what are they for? anyone know?

Replies:

Posted By: Gullanian
Date Posted: 22 February 2005 at 9:14am

I've never used a hyperlink type before. Why dont you store it as text and do:

<a href="<%=var_URL%>"><%=var_URL%></a>

Posted By: Dekieon
Date Posted: 22 February 2005 at 9:15am

Yes I had thought of putting the hyperlink in just as text, but then i would loose the access to where the hyperlink actually goes from microsoft access, which is something I want to keep.

Posted By: Gullanian
Date Posted: 22 February 2005 at 10:22am

Try

<a href="<%=Replace(var_URL,"#","")%>"><%=Replace(var_URL,"#","")%></a>

Posted By: Dekieon
Date Posted: 22 February 2005 at 11:09am

yes, that did it.

Thanks a bunch