2. ASPRunnerPro General questions
  3. Add Hyperlink to DB Column
This topic is locked

Add Hyperlink to DB Column

 		2/14/2005 14:51:38
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

http://intranet.intranet.com
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.