if i loop through a recordset using "do while not rs.eof" and my ending code is rs.movenext
               loop

and then a while later in my code i repeat this same operation (code), where is the cursor in ralation to the recordset once i start this next block of code? is it at the end of the recordset, beginning, or somewhere in between?

when it hits rs.EOF, it stays there unless you move it using a rs.moveprevious, or rs.movefirst. These 2 options will only work if the recordset was opened in a way that allows moving back up the recordset.

Chris

how would i open the connection where it would allow backward movement?

this is how i'm opening may database connection...

option explicit

dim conn, rs, sql, dbPath

set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.RecordSet")

dbPath = Server.MapPath("asp/davidData.mdb")

conn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =" & dbPath

I have never needed to go backward on an ASP page at my current job, so I am not exactly sure right off without searching for sample code. Does anyone else know?

There are other parameters when opening the rs. One is locktype which I believe is the one that controls this. I cannot remember the exact syntax and all my code I used it with is at my other job.

Chris

thank you. anyone else?

If you want a recordset that supports .MoveFirst, try this:

    This creates a client side cursor that will support backwards navigation in the Recordset.

For more info, check out:
http://www.adopenstatic.com/faq/800a...dsetOpenSyntax

HtH

Imar




---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Alternatively you could just get the recordset into an array using GetRows() then you can access it as many times as you like without having to use expensive cursors.