[asp] displaying url

[chenks]

got a database where one of the fields is set to hyperlink format. when the asp page displays it... it is coming up as

subtitled#http://Subtitled#

when it should really be

[url=http://subtitled]subtitled[/url]

the asp code i am using to display the data is

Set rstSimple = cnnSimple.Execute("SELECT * FROM schedule") 
<% rstSimple.Fields("Film_1").Value %>

how can i make this display so that it is an actual hyperlink and clickable?

[davemarks]

I wouldn't bother using the URL field, just change it to text of the appropriate length and build the link using asp

[chenks]

all the data displayed on the asp page is taken from the access database... so wouldn't it be easier to take the url from the database?

surely it is possible to do though... regardless of whether it is easier or not? if it is possible i would like to give it a try at least!

[chenks]

problem solved for now

created another field in the DB.... one field contains the link, the other contains the display name

<a href="<%=rstSimple.Fields("Film_1_Info2").value %>"><%=rstSimple.Fields("Film_1_Info").value %></a>