Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

Hyperlink recordset field from access database in web page.

I have a link table in an access database and using a query I want to call the links of an employee into a web page.  The link_name field is text and the link_url field in a hyperlink in the database.

 I need to be able to call the recordset and click on the links which would direct me to another web page.  Currently clicking the link puts the url in the current browser url:

http://localhost/mylinks.asp#http://www.ultra-fitmagazine.com#

Code:
<table border="1" width="100%">
<tr>
<th>My Links</th>
</tr>
                              
<%

sql = "SELECT tblLink.link_name, tblLink.link_url FROM tblEmployee INNER JOIN tblLink ON tblEmployee.User_id = tblLink.user_id"

rs.open sql,myconn,3,3
rs.movefirst
do until rs.eof
%>

<tr><td>
<a href="<%=rs("link_url")%>"><%=rs("link_name")%></a></td></tr>

<%
rs.movenext
Loop      
rs.close
%>      
</table>

Please can somebody help me solve this problem?

Thanks
0
ladykh
Asked:
ladykh
  • 2
1 Solution
 
venkateshwarrCommented:
try this code

<table border="1" width="100%">
<tr>
<th>My Links</th>
</tr>
                         
<%

sql = "SELECT tblLink.link_name, tblLink.link_url FROM tblEmployee INNER JOIN tblLink ON tblEmployee.User_id = tblLink.user_id"

rs.open sql,myconn,3,3
rs.movefirst
do until rs.eof
%>

<tr><td>
<%
    Dim list,lnk_url
    list = Split(rs("link_url"), "#")
    lnk_url = list(1)
%>
<a href="<%=lnk_url%>"><%=rs("link_name")%></a></td></tr>

<%
rs.movenext
Loop    
rs.close
%>    
</table>
0
 
ladykhAuthor Commented:
To venkateshwarr
Thank you very much, it worked perfectly!
Thanks
0
 
venkateshwarrCommented:
you are welcome..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now