We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

View Complete Thread
  • Re: Problem displaying database info on page

    Aug 15, 2005 02:59 PM|tomkmvp|LINK

    Here's one way:

    qry = "SELECT jersey_number, player_name, position FROM " & tablename

    Set oRS = oConn.Execute(qry)
    response.write "<table>"
    Do While not oRS.EOF
    response.write "<tr><td>" & oRs(0) & "</td>"
    response.write "<td>" & oRs(1) & "</td>"
    response.write "<td>" & oRs(2) & "</td></tr>"
    oRS.movenext
    Loop
    oRS.close