Formatting a string as a hyperlink

Forgive the probably simple problem for you folks but here's what I'd like to do

I need to format the following string (ouputted from an access database) as a hyperlink opened in a new window

<td><%=(rsLinks.Fields.Item("url").Value%></td>

I've tried various permutations of this but nothing formats it properly

Your suggestions would be appreciated

John

There's a lot of ways to do this but the simplest is

Code: Select all

<td>" target="_blank"><%= rsLinks.Fields.Item("url").Value%></td>

There should be a space after the 'a' in 'ahref' (forum tried to make it into a link without it). And I would use the shorthand for

Code: Select all

 rsLinks.Fields.Item("url").Value

which is

Code: Select all

 rsLinks("url")

Thanks very much that worked like a charm

I don't know how confident you are that the URLS in your database all have http:// in front of them, but I know that in the past I have had to check it was there so this might be useful.

'## 1st put the DB field into a temporary string
strURL = rsLinks("url")

'## now see if the first 4 characters or strURL are "http" and if not, make it so they are "http://"
If Lcase(Left(strURL,4))<>"http" then
strURL="http://" & strURL
End if

Then use the same code as earlier

<td><%=strURL%></td>