[sasi]

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?....

[Shane]

What's being displayed now?

[Stealth]

<%
rs.open "SELECT * FROM Uploadnotes",con
do while not rs.eof

tajuk = rs.getString("Title");
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>
<%
rs.movenext
loop

rs.close
%>