How do I page through a recordset? - ASP FAQ

countSQL = "SELECT COUNT(*) FROM SampleCDs WITH (NOLOCK)" RowCnt = 0 set rs = conn.execute(countSQL) if not rs.eof then RowCnt = clng(rs(0)) end if if RowCnt = 0 then Response.Write "No rows found." Response.End

databases.aspfaq.com