records from database with the link

i would like to display the filenames from a database together with the it's own link.so that when i click on the link of the file name it..should be able to show the content of the file...how to do this..plz help


currently im having the jsp code for it as below:


<%
stmt = con.createStatement();
rs = stmt.executeQuery("SELECT * FROM Uploadnotes");

if (rs != null)
{
while (rs.next()) {
String tajuk = rs.getString("Title");
String path = rs.getString("Filepath");

%>
<tr>
<td>
<center>
<p><a href =<%=path%> > <font face="Arial, Helvetica, sans-serif" size="2" color="#0000FF"><b><%=tajuk%></b></font></a></p>
</center>
</td>
</tr>
<%
}
}
stmt.close();
con.close();
%>



how to do this using asp?....

tajuk = rs("Title")
path = rs("Filepath")

try this coding i beive that it should work now.

<p><a href ="<%=rs("path")%>" > <font face="Arial, Helvetica, sans-serif" size="2" color="#0000FF"><b><%=rs("tajuk")%></b></font></a></p>