Webdesign - Script - ASP - Objects - ADODB.Connection - Recordset >Fields gox.gif (837 bytes)ADO: Recordset
set rs = Server.CreateObject("ADODB.Recordset")
---
rs.Close

ADODB.Recordset - Egenskaber
v EOF

EOF (EndOfFile)
rs.MoveFirst
Do While Not rs.EOF
  ---
  rs.MoveNext
Loop
>MoveNext

ADODB.Recordset - Metoder
v Close, MoveFirst, MoveNext, Open

Open
sql = "SELECT jersey, fname, sname, position " & _
      "FROM roster " & _
      "ORDER BY jersey;"
rs.Open sql, cn, 3, 3
>Database: Players
Close
rs.Close
MoveFirst
>MoveNext
MoveNext
rs.MoveFirst
Do While Not rs.EOF
  Response.Write nn(rs.Fields("jersey")) & ", " & _
                    rs.Fields("fname") & " " & _
                    rs.Fields("sname") & ", " & _
                    rs.Fields("position") & "<br>" & vbCrLf
                    rs.MoveNext
Loop
>Database: Players