creating hyperlink in SQL Server2005
-
I had a project in MS access 2003 now I converted that to SQL server where there is some fields in each table which has the hyperlink link to a scanned pdf file. while converting the files the database is running very well but I can not get to my scanned files and the hyperlink is not coming in SQL server to click to get to the specified scanned files.just the path is coming in text format only could you anyone help me.
-
I had a project in MS access 2003 now I converted that to SQL server where there is some fields in each table which has the hyperlink link to a scanned pdf file. while converting the files the database is running very well but I can not get to my scanned files and the hyperlink is not coming in SQL server to click to get to the specified scanned files.just the path is coming in text format only could you anyone help me.
Saleem Tahiri wrote:
just the path is coming in text format only
Because that is what is stored. You cannot (as far as I know) store a hyperlink in sql, just text so you need to build the hyperlink when you retrieve the data.
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
-
I had a project in MS access 2003 now I converted that to SQL server where there is some fields in each table which has the hyperlink link to a scanned pdf file. while converting the files the database is running very well but I can not get to my scanned files and the hyperlink is not coming in SQL server to click to get to the specified scanned files.just the path is coming in text format only could you anyone help me.