ladykh
asked on
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("li nk_name")% ></a></td> </tr>
<%
rs.movenext
Loop
rs.close
%>
</table>
Please can somebody help me solve this problem?
Thanks
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.movenext
Loop
rs.close
%>
</table>
Please can somebody help me solve this problem?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you are welcome..
ASKER
Thank you very much, it worked perfectly!
Thanks