How do I publish database links to web?

M

mel8twelve

One of the field types in my database is a hyperlink field. But when I try to
publish this information to the web, the links do not link. The text is
there, but is not "hyper." How do I get the links to link when my database
goes live?
 
T

TB

If your web server supports ASP you could write create a page containing
something like this:

(Assuming that you have already set up your connection to your database
which contains a table called "mytable" with a column that contains the
hyperlink called "link" and that the selected record is defined by the value
of a column called "ID")

<%
Dim StrSQL, Chosenrecord, Link
Chosenrecord = 1 ' Or whatever is relevant
StrSQL = "select link from mytable where ID = " & Chosenrecord
Set RS = Server.CreateObject("ADODB.Recordset")
RS.open StrSQL, Conn, 0, 1, 1
Link = RS.getstring()
RS.close
Set RS = nothing
response.write "Click <a href=" & Link & ">here</a> to access the linked
page."
%>

TB
 
A

adsl

mel8twelve said:
One of the field types in my database is a hyperlink field. But when I try
to
publish this information to the web, the links do not link. The text is
there, but is not "hyper." How do I get the links to link when my database
goes live?
 
A

adsl

TB said:
If your web server supports ASP you could write create a page containing
something like this:

(Assuming that you have already set up your connection to your database
which contains a table called "mytable" with a column that contains the
hyperlink called "link" and that the selected record is defined by the
value of a column called "ID")

<%
Dim StrSQL, Chosenrecord, Link
Chosenrecord = 1 ' Or whatever is relevant
StrSQL = "select link from mytable where ID = " & Chosenrecord
Set RS = Server.CreateObject("ADODB.Recordset")
RS.open StrSQL, Conn, 0, 1, 1
Link = RS.getstring()
RS.close
Set RS = nothing
response.write "Click <a href=" & Link & ">here</a> to access the linked
page."
%>

TB
 
Top