reuse RecordSet

[TheCandyman]

Dim myConn2,myPath2
Set myConn2 = Server.CreateObject("ADODB.Connection&quot
myPath2 = Server.MapPath("Accessdb/WEBDB.mdb&quot
myConn2.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & myPath2 & " ;"

Dim rs2
Set rs2 = Server.CreateObject("ADODB.RecordSet&quot

Dim mySQL2
mySQL2 = "SELECT * FROM WEB_CODE
rs2.Open mySQL2, myConn2

do until rs2.EOF
response.write rs2("Part&quot
rs2.MoveNext
loop


************
My question is, once i go through a loop, how do i reuse the recordset to do a different search. i tried rs.BOF to start at begining of file but it doesn't like that... any ideas??

 

[onpnt]

rs.movefirst

_________________________________________________________
for the best results to your questions: FAQ333-2924
_{01001111 01101110 01110000 01101110 01110100}

http://www.onpntwebdesigns.com/newsite/index.asp

[/sub]

 

[mikecx]

Have you tried Rs.MoveFirst? NOt sure if it helps you at all but it should take it to the begining of the Rs again.