This topic is locked

Add Hyperlink to DB Column

2/14/2005 2:51:38 PM
ASPRunnerPro General questions
R
Raiders1 author

Need to add hyperlink to DB Column (computer_name) to launch VNC to take over computer. All Hyperlinks will be the same path.
Where do I add, I have ASPRunner Pro 3.1?
Thank You

Sergey Kornilov admin 2/14/2005

Hi,
probably you need to explain how VNC links look.

R
Raiders1 author 2/14/2005
Sergey Kornilov admin 2/14/2005

Well, if VNC links are the same as HTTP links just set View as type of this field to "Hyperlink".

R
Raiders1 author 2/14/2005

Links are not in SQL, need to set as static link from ASP Runner.
GetHyperlink = "<a href="intranet.intranet.com"" & str & """" & Target & ">" & strTitle & "</a>"
Need to add static URL.

Sergey Kornilov admin 2/15/2005

you can modify SQL query for this purpose:

select ...

'http://intranet.intranet.com/'; + HyperlinkField as NewHyperlinkField

from tablename


After that set View as type of NewHyperlinkField to Hyperlink.
I hope this helps.