Displaying a Web Address from Access

[TonyU]

hello all....
I have an Access database with a web address field and I'm trying to display that field on a different page, but my address field is not showing as a link, what's the way to show the address as a link??? thanks guys Tony

 

[Guest_imported]

This is just a display part, without opening connection and recordset. Say, your table has a field, named "a_link". So your recordset(oRS) will contain this field:


<%
if oRS.bof and oRS.eof then
response.write(&quot;No records found...&quot
response.end
end if
do while not oRS.eof
%>
<a href='<%= oRS(&quot;a_link&quot%>'><%= oRS(&quot;a_link&quot%><br>
<%
oRS.movenext
loop
%>

This will display all links one under another. You can format output differently - say, in a table. It's up to you.

 

[TonyU]

I've tried your suggestion using sigle quotes and double quotes and is not working. I don't know what it could be. Tony

 

[hblackorby]

Basically &quot;guest&quot; is saying write the beginning of an HREF tag
<A HREF=&quot;
then write your stored URL
then close your HREF tag
&quot;>
Then write your link wording or the link again and then the </a> part.

You can use single quotes to surround the URL or if you want, double quotes. To write a double quote in a response.write string do &quot;&quot;. Doing it twice will cause it to be written instead of closing your string. So:
response.write &quot;<A HREF=&quot;&quot;&quot; & rs(&quot;URL&quot & &quot;&quot;&quot;>&quot; & rs(&quot;URL&quot & &quot;</a>&quot; Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[TonyU]

I got it, tyvm for your input guys Tony