adOpenForwardOnly and input parameters

[unseth]

normally i open my recordset like so:

set objRS = Server.CreateObject("ADODB.Recordset&quot
objRS.LockType = 1 'adLockReadOnly
objRS.CursorType = 0 'adOpenForwardOnly

but now i want to use this method so I can use input parameters in my SPO for recordcounts. Does this method default to adOpenForwardOnly and adLockReadOnly or do I have to do something else to it?

Set objCommand = Server.CreateObject("ADODB.Command&quot
objCommand.ActiveConnection = objConn
objCommand.CommandType = adCmdStoredProc
objCommand.CommandText = "usp_pagingtest1"
objCommand.Parameters.Append objCommand.CreateParameter("@SrchCriteria", adVarChar, adParamInput, 50, strSrchCriteria)
objCommand.Parameters.Append objCommand.CreateParameter("@TotalRecs", adInteger, adParamOutput, 4)
Set objRS = objCommand.Execute


thanks

 

[unseth]

I think i just need to add these lines:

objCommand.CursorType = adOpenForwardOnly
objCommand.LockType = adLockReadOnly

seems that might work the same way on a command as a recordset..?

 

[durug]

The methods from above don't exist.
Check here all the reference about Command Object:

http://www.devguru.com/Technologies/ado/quickref/command.html

regards,
Durug

 

[unseth]

so how can i make it forwardonly and readonly and still use input parameters?

 

[durug]

by default is readonly and forwardonly so you don't have to specify any aditional parameters

 

[unseth]

excellent! thanks durug