To anyone who can help;



How can I insert a hyperlink from a access database table to a asp using a

table.  I have the full hyperlink in a table called "SpecialtyTools" and the

field is called InstructionsLinked.  I have the value being placed in a

table, but it only list that value like text instead of being a link, how

can I change that?  Is their an easier way, currently I am using visual

interdev and f

rontpage for graphics.



If anyone could help that would be great, 



Thanks,



Sonny Jimenez

Sjimenez3@d...

xxx.xxx.xxxx

Since you didn't post any code, I can only guess how you are doing thing now.



Suppose you have something like this:

<%

         ' Pure ASP example

         ' Open recordset

         ' Write out the link:

         Response.Write(Recordset("FieldWithLink"))

%>



or maybe you have this:



<!-- ASP and HTML example -->

<%=Recordset("FieldWithLink")%>



In that case, simply reuse the statement Recordset("FieldWithLink") or 

assign it to a variable:



<%

         ' Pure ASP example

         Dim sMyLink

         sMyLink = Recordset("FieldWithLink")

         Response.Write("<A HREF=""" & sMyLink & """>" & sMyLink " "</a>")

%>



This will link a text (the URL) to the actual URL.



Or do this: (which will perform just a little slower):



<!-- ASP and HTML example -->

<A HREF="<%=Recordset("FieldWithLink")%>"><%=Recordset("FieldWithLink")%></a>



HtH



Imar





At 07:18 PM 1/30/2001 -0800, you wrote:





>To anyone who can help;

>

>How can I insert a hyperlink from a access database table to a asp using a

>table.  I have the full hyperlink in a table called "SpecialtyTools" and the

>field is called InstructionsLinked.  I have the value being placed in a

>table, but it only list that value like text instead of being a link, how

>can I change that?  Is their an easier way, currently I am using visual

>interdev and f

>rontpage for graphics.

>

>If anyone could help that would be great,

>

>Thanks,

>

>Sonny Jimenez

>Sjimenez3@d...

>xxx.xxx.xxxx