Changing cursor type with stored procedure in ASP

Question

Using ASP, I want to call a stored procedure that returns a recordcount.

I understand that I have to change the cursor type to adOpenKeyset or adOpenStatic to return a recordcount.

What I don't understand is how to modify my vbscript so that it changes the cursor type when calling the procedure.

currently I say cm.commandtype = adCmdStoredProc ..... rs = cm.execute

I suspect I need to add a parameter to the cm.execute but I cant figure out what to add and how to add it.

Thanks

DMD

Answer 1

Use the Open method on your recordset instead. Not 100% sure on the syntax, but something like:

rs.Open cm, , adOpenStatic