Is there a way to retrieve the actual url to a content record from the database. I am writing a Alpha Tagged list webpart and I am having issues with content since the blob field is longer than I can read in SQL.
Is there a way to retrieve the actual url to a content record from the database. I am writing a Alpha Tagged list webpart and I am having issues with content since the blob field is longer than I can read in SQL.
The SQL function
The SQL function dbo.asi_PublishedDocumentPath(DocumentVersionKey) will give you the full path to the content record. Just replace the @ with ~ and append .aspx to get the root-relative path to the published ASPX file.
Eric Means
System Architect, ASI