Webmaster Forum / ASP / Database Access / August 2007

I want to invoke the Execute method of a Command to obtain a record set, then
reuse that record set twice. A rough code outline appears below. It appears
that the record set return from Command.Execute is non-rewindable, however;
upon attempting the second "MoveFirst" I get this error:
"error '80040e18'  Rowset position cannot be restarted."
Is there a straightforward way to make this record set reusable?

==========================
Set Cmd=CreateObject("ADODB.Command")
Cmd.CommandText = sqlText
Set Cmd.ActiveConnection=MyConnection
arParams = Array(IDCustomer, IDUser)
Set rs = Cmd.Execute(,arParams, adCmdText)

<%rs.MoveFirst
Do While Not rs.EOF%>
. . .
<%rs.MoveNext
Loop%>
. . .
<%rs.MoveFirst
Do While Not rs.EOF%>
. . .
<%rs.MoveNext
Loop%>

==========================