Render a Document in Exchange 2000

Rendering a document via the browser that is stored in the Web Storage System (WSS) folder is very straightforward.  You can achieve this simply by creating an HTML link that points to that document. There are many ways to accomplish this; I’ll show you two.  In method one, you will manually construct the link.  In method two, you construct links using the ADO object. 

Method one:  Manually constructing the link

Syntax

http://<Server Name>/<Folder Path>/<Document Name>

Parameters

<Server Name>

Specifies the name of your Exchange 2000 server

<Folder Path>

Specifies the storage path of your document

<Document Name>

          Specifies the name of your document

Example

The following example illustrates a manually constructed link.

http://MyServer/MyStore/MyParentFolder/MyFolder/My.doc

Method Two:  Constructing a document link using ADO

The example code below will retrieve all documents in the http://Myserver/MyStore/MyParentFolder/MyFolder/ folder that are not hidden and have a display name of My.doc.  This example will work exactly as method one does if the display name for you document is unique within the context of the folder.  Please also reference my article on generating unique IDs.

Example

     Set Conn = server.CreateObject("ADODB.Connection")

Set Res = server.CreateObject("ADODB.Recordset")   

strDataURL = "http://MyServer/MyStore/"

StrSQL = "SELECT ""DAV:herf"" " & _

        "FROM SCOPE('SHALLOW TRAVERSAL OF """ & _

        "http://MyServer/MyStore/MyParentFolder/MyFolder"" ') "   & _

        """DAV:ishidden"" = FALSE AND ""DAV:displayname"" = " & _

        "'My.doc'"

With Conn

    .Provider = "ExOLEDB.DataSource"

    .Open strDataURL

End With

With Res

    .Open StrSQL, Conn, adOpenForwardOnly, adLockReadOnly

    .MoveFirst

    Do Until .EOF

        strHREF = .Fields("DAV:href")

        Response.Write ("<A href='" & strHREF & "'>" & strHREF & "</A>")

    Loop

    .MoveNext

End With

RETURN to my Article Index