S
SK
I have inserted a Spreadsheet web component into a web page that uses a SQL
Server data source.
I am attempting to create a hyperlinked column in the spreadsheet component
called 'EDIT'.
I am using the followingSQL:
select table_name, user_name,
'=hyperlink("http://tpa61b/topicDBASP-NET10\Projects\TOPIC\DATAENTRY\REFEREN
CE\PERMISSIONS\PERMISSIONSEDIT.asp?TABLE_NAME='
+table_name+'&USER_NAME='+User_name+'", "Edit")' as Edit, read_perm,
add_perm, update_perm, delete_perm from "EITCtest"."dbo"."PERMISSIONS"
The column EDIT appears, but the actual hyperlink formula appears instead of
the 'Edit' labeled hyperlink. If the user double-clicks the hyperlink
formula, it converts to a normal looking hyperlink with the 'Edit' label and
launches my page. I want the page to come up with the 'Edit' labels.
Server data source.
I am attempting to create a hyperlinked column in the spreadsheet component
called 'EDIT'.
I am using the followingSQL:
select table_name, user_name,
'=hyperlink("http://tpa61b/topicDBASP-NET10\Projects\TOPIC\DATAENTRY\REFEREN
CE\PERMISSIONS\PERMISSIONSEDIT.asp?TABLE_NAME='
+table_name+'&USER_NAME='+User_name+'", "Edit")' as Edit, read_perm,
add_perm, update_perm, delete_perm from "EITCtest"."dbo"."PERMISSIONS"
The column EDIT appears, but the actual hyperlink formula appears instead of
the 'Edit' labeled hyperlink. If the user double-clicks the hyperlink
formula, it converts to a normal looking hyperlink with the 'Edit' label and
launches my page. I want the page to come up with the 'Edit' labels.