read text from textfile

[vasanthspiky28]

the below code displays the details of tittles from a table papers wat i nee is f i click the displayed tittle a textfile of that tittle should get opened help me..

<%
Dim con,rs,sl
 
    set con=server.CreateObject("ADODB.Connection")
    set rs=server.CreateObject("ADODB.Recordset")
    con.open Application("db")    
sl = "SELECT * FROM papers "
rs.Open sl,con
Response.Write "<table width='100%'>"
Do While Not rs.EOF
response.Write "<tr><td><img src=""images\free_bullet.gif"" width=""10"" height=""10""></td>"
Response.Write "<td><a class=a1 href=" & rs("Upload1") & ">" & rs("Tittle1") & " <br></td></tr>"
rs.MoveNext
Loop
Response.Write "</table>"
rs.Close
con.Close%>

[jhardman]

is the field "upload1" the virtual path to the text file? If so, then this should work:

<%
Dim con,rs,sl
 
    set con=server.CreateObject("ADODB.Connection")
    set rs=server.CreateObject("ADODB.Recordset")
    con.open Application("db")    
sl = "SELECT * FROM papers "
rs.Open sl,con %>
<table width="100%">
<%
Do While Not rs.EOF %>
   <tr><td><img src="images\free_bullet.gif" width="10" height="10"></td>
   <td><a class="a1" href="<%=rs("Upload1")%>"><%=rs("Tittle1")%>
   <br></td></tr>
   <%
   rs.MoveNext
Loop 
rs.close 
con.Close %>
</table>
 

Let me know if this helps.

Jared

[vasanthspiky28]

thaks jared it worked..