3.2.0

Hyperlink

I am reading in data from a database and pushing it out using a simple grid. The first two fields are file names. However, I have file routines which search and tell me whether or not the file exists. If the file exists, I want to put a link to it -- if not, I want to just leave it alone and continue to the next. I am having trouble how to put in a link?

Any help, I am new. Below is a briefly what I tried:

For i=0 to (column_count-1)
if i = 0 then
funddocfile = oRecordset(i)
filepath = "./FundingDocs/" + funddocfile + ".pdf"
if CheckFileExists(filepath) Then
rows = rows & """" & activewidgets_html("<a href=""/Contracts/index.html"">" & oRecordset(i) & "</a>") & """, "
else
rows = rows & """" & activewidgets_html(oRecordset(i)) & """, "
end if

This obviously doesn't work so how do you do what I am trying to do....

Thanks.
John
June 28,
I am seeing all the javascript code go by, but I am not sure to incorporate the solutions into the vbscript code. How do I set a hyperlink from within the vbscript. I am assuming it is in here:

s = vbNewLine
s = s & "<" & "script" & ">" & vbNewLine
s = s & columns & vbNewLine
s = s & rows & vbNewLine

s = s & "try {" & vbNewLine
s = s & " var " & name & "= new Active.Controls.Grid;" & vbNewLine
s = s & " " & name & ".setRowCount(" & row_count & ");" & vbNewLine
s = s & " " & name & ".setColumnCount(" & column_count & ");" & vbNewLine
s = s & " " & name & ".setDataText(function(i, j){return " & name & "_data[i][j]});" & vbNewLine
s = s & " " & name & ".setColumnText(function(i){return " & name & "_columns[i]});" & vbNewLine
s = s & " document.write(" & name & ");" & vbNewLine
s = s & "}" & vbNewLine
s = s & "catch (error){" & vbNewLine
s = s & " document.write(error.description);" & vbNewLine
s = s & "}" & vbNewLine

s = s & "</" & "script" & ">" & vbNewLine
John
June 29,

This topic is archived.

See also:


Back to support forum