Forum Moderators: open

Message Too Old, No Replies

[asp] displaying url

         

chenks

12:37 pm on Dec 21, 2003 (gmt 0)

10+ Year Member



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

1:33 pm on Dec 21, 2003 (gmt 0)

10+ Year Member



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

chenks

7:33 pm on Dec 21, 2003 (gmt 0)

10+ Year Member



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

2:06 pm on Dec 22, 2003 (gmt 0)

10+ Year Member



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>