on my web server.
Here is the .aspx file:
************************************************** ***************
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ import Namespace="System.IO" %>
<Script Runat="Server">
Sub Page_Load
Dim conPubs As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrAuthors As SqlDataReader
' Retrieve records from database
conPubs = New SqlConnection(
System.Configuration.ConfigurationSettings.AppSett ings("MM_CONNECTION_STRING
_Contour_Server"))
cmdSelect = New SqlCommand( "Select title,fullFileName From
openworx..QADocs order by title", conPubs )
conPubs.Open()
dtrAuthors = cmdSelect.ExecuteReader()
' Bind to Repeater
rptAuthors.DataSource = dtrAuthors
rptAuthors.DataBind()
dtrAuthors.Close()
conPubs.Close()
End Sub
</Script>
<html>
<head><title>Repeater.aspx</title></head>
<body>
<form Runat="Server">
<asp:Repeater
ID="rptAuthors"
Runat="Server">
<ItemTemplate>
<a href="<%# Container.DataItem("fullFileName") %>" ><%#
Container.DataItem("title") %></a><br>
</ItemTemplate>
<separatortemplate>
<hr></separatortemplate>
</asp:Repeater>
</form>
</body>
</html>
************************************************** **************************
*******
This gives me a list of files from my QADocs table that generates a page
like so:
************************************************** **************************
*****
<html>
<head><title>Repeater.aspx</title></head>
<body>
<form name="_ctl0" method="post" action="TMPbxwz1g6rr.aspx" id="_ctl0">
<input type="hidden" name="__VIEWSTATE" value="dDwtMjA0Nr9vNNYoX" />
<a href="c:\QA Docs\QSF 6.1.4 - Acknowledgmnt of Designated Reading.doc"
Acknowledgement of Designated Reading</a><br>
<hr>
</form>
</body>
</html>
************************************************** **************************
**************
The link looks like this:
file:///c:/QA%20Docs/QSF%206.1.4%20-%20Acknowledgmnt%20of%20Designated%20Rea
ding.doc
As I said when I click on the link, a page opens up as a word document on
the web server, but not on any other workstation. It just sits there. How
do I get it to open the file?
Also, is there a way to tell the link to open up the file in a separate
window as well as to be read only?
Thanks,
Tom.
