Display Database information as link

[Yorkshire Newbie]

I am trying to display URLs brought in from a database as hyperlinks on a page.
If I make the text representing the URL static (the same for all) then it's ok.
(See 'click here' in the code). But if I put the dynamic information in, then
nothing is displayed. (substitute 'click here' for '<%=(All_Open...')

<td width="788"><div align="justify"><span class="index_text"><span
class="news_title">Hyperlink:</span></span> <a
href="<%=(All_Open_Calls.Fields.Item("Hyperlink"). Value)%>" target="_blank">
Click here </a> </div></td>

Thank you for your help

[wizardofdata]

Yorkshire,

After the target="_blank"> instead of click here, you need to put in your
record set. For example, you may want to try the following code:

<a href="<%=(All_Open_Calls.Fields.Item("Hyperlink"). Value)%>"
target="_blank"> <%=(All_Open_Calls.Fields.Item("Hyperlink").Value) %></a>

This will then create the link that will also have the hyperlink info from
your database.

I did something similar to this a while back and had to pull out my old code.
Are you plugging into the db the actual hyoerlink or just text? I also had
mine pulling from the database the record by ID number, rather than coding into
the db the actual hyperlink.

Let us know how it goes.

[Yorkshire Newbie]

That has helped, thank you. I realised that I had the 'hyperlink' info in the
database stored as memo rather than a 255 character text. I switched that over
and combined with your suggestion, everything works great. Thank you for your
help!

[wizardofdata]

My pleasure!