an hyperlink held in a database field

[Shirley]

Using vbscript - can I make a hyperlink that is held in a database active without having to add all the code to the field itself.

<a href="http://www.ocean-finance.co.uk/">Ocean Finance</a> this code works in the database field.

[monte96]

I think I see what your asking..

if you store:

<a href="http://www.ocean-finance.co.uk/">Ocean Finance</a>

in a db field, when you read that field in, wherever you want the link to be do:

<%=rs.Fields("MyLinkField")%>

The ASP server side processer will replace it with the data in the MyLinkField field from the recordset. You can even do it in a for or do loop.

[monte96]

On the other hand, after a second read of your post, if you were to store say:

MyLinkField = "http://www.ocean-finance.co.uk"
MyDescField = "Ocean Finance"

You could then do something like this:

<a href=<%=rs.Fields("MyLinkFIeld")%>><%=rs.Fields("MyDescField")%></a>

Now, if I have just totally missed the point, please clarify what your trying to do :c)