RecordSet Question 1

[contra]

Hi everybody!

I have here a small dilema.
I try to run a stored procedure from the command object and return a recordset. Everything works fine. After that with the recordset.recordcount method I need to return the nr of records.

set cmd = Server.CreateObject("ADODB.Command&quot
cmd.ActiveConnection = "Provider=SQLOLEDB;Server=local;Database=INTRA;UID=sa;PWD="
cmd.CommandText = "sp_inventory"
cmd.CommandType = 4
cmd.Parameters.Append cmd.CreateParameter("@clickclass",129,1,2,"AC&quot
Set objRS = cmd.Execute

But because the rcordset is forwardonly and readonly the recordcount will return -1. How can I declare the type of cursor, cursor location, etc for this recordset in this code so that I can return the number of records?

Thanks a lot,
Contra

 

[Palooka]

I haven't done it with the command object, so I don't know. But if you could change it, something like this might work:

set conn= <your connection string>
set rs = Server.CreateObject(&quot;ADODB.recordset&quot;)

sql=&quot;sp_inventory &quot; & parameter1 & &quot;, &quot; & parameter2

rs.CursorLocation = adUseClient '=3
rs.CursorType = adOpenStatic '=3
rs.LockType = adLockBatchOptimistic '=4

rs.Open sql, conn

Hope this helps,
Palooka

 

[durug]

Check out this example!

set cn = Server.CreateObject("ADODB.Connection&quot
set cmd = Server.CreateObject("ADODB.Command&quot
set objrs = Server.CreateObject("ADODB.Recordset&quot
cn.CursorLocation = adUseClient
cn.Open "Provider=SQLOLEDB;Server=local;Database=INTRA;UID=sa;PWD="
set cmd.ActiveConnection = cn
cmd.CommandText = "sp_inventory_Class_click"
cmd.CommandType = 4
cmd.Parameters.Append cmd.CreateParameter("@clickclass",adChar,adParamInput,2, Label)
cmd.Parameters.Append cmd.CreateParameter("@countnr",adInteger,adParamOutput)
set objrs = cmd.Execute

regards,
durug