scrolling a result set

<i><b>Originally posted by : Mike (mlauve@unisrv.com)</b></i><br />My ASP page provides access to an SQLServer database. When I get the result set I can only scroll from the first record to the second or from the first record to last record and back again. There are 18 records in the table(and result set). I'm using a cursor type of dynamic and pessimistic lock. <br /><br />thanks :^)<br />

<i><b>Originally posted by : Doug Seven (doug.seven@codejunkies.net)</b></i><br /><br /><br />Try doing a Response.Write rs.RecordCount to make sure all 18 records came back.<br /><br />If all of them wer returned try using the rs.Move(2) command to skip a record and see if you can get to it.<br /><br />Unless the connection to the DB is constant, the RS automatically converts to STATIC. you can not have a dynamic RS in a web page, they are disconnected.<br /><br />Doug Seven, MCSD<br />CodeJunkies.Net / ASPNextGen.com<br />doug.seven@codejunkies.net<br /><br />Two new sites are coming, dedicated exclusively to ASP+. Stay tuned for www.ASPNextGen.com and www.theFutureOfASP.com, both brought to you exclusively by CodeJunkies.Net.<br /><br />http://www.codejunkies.net<br />------------<br />Mike at 7/25/2000 3:08:43 PM<br /><br />My ASP page provides access to an SQLServer database. When I get the result set I can only scroll from the first record to the second or from the first record to last record and back again. There are 18 records in the table(and result set). I'm using a cursor type of dynamic and pessimistic lock. <br /><br />thanks :^)<br />