display web address with link from database!

[Monie]

I have a form that will ask the user to enter some web address, for example "www.yahoo.com". this data will be stored in the database, and then will be display in a display.asp page!

How can i make the web address active in the display.asp page?
The user can click at the link, and the website will be opened!

[courtjester]

This is done like this...

Code: Select all

Response.Write("<a href=")
Response.Write(recordSet("Address"))
Response.Write(">")
Response.Write(recordSet("Address"))
Response.Write("</a>")

There ya go

[Rob]

Or better still, for less code (and quicker):-

Code: Select all

">LinkText

[courtjester]

Yeah, but the LinkText won't be database driven so that's not what he asked for [:P]. lol.

I was taking it slow with him (look at his last posts).

Code: Select all

"><%=RecordSet("LinkName")%>

When you type in the <%= it automatically assumes Response.Write . Just make sure your connected to your database before this and make sure you close the connection after this.