I am very new to ASP but trying to learn, so any help is appreciated.

I am trying to create an asp page which will display results from a SQL Server database in an HTML table. The results (recordsets) to appear as hyperlinks to word documents. I know how to create a connection to a database but unclear on the other stuff.

Hi,

  When you are retrieving data from database, form a hyperlink using

.....
while not Rs.EOF
strHTML=strHTML & "<a href='" & filename.doc & "'>" & filename.doc & "</a>"
   Rs.movenext
wend

finally print that strHTML

response.write strHTML


----------
Rajani

To put each link in a table row (this asumes you have the filenames in your table, RS(0) is the record containing the filename):

<% if NOT RS.Eof then
         response.write "<table>"
         do until RS.EoF
         response.write "<tr><td><a href='" & RS(0) & "'>" & RS(0) & "</a></td></tr>"
         RS.MoveNext
         loop
          response.write "</table>"
     Else
         response.write "<table><tR><td>The record set is empty</td></tR></table>"
     End If %>


Wind is your friend
Matt

Thanks for the reply...very helpful to a newbie like me.