RecordCount on Stored Procedure

Im trying to do a "RecordCount" on stored procedure that returns a Recordset
but i keep getting :

Object doesn't support this property or method:

what setting do i have to change to the code that dreamweaver has written to
get this to work ?

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_artco_STRING
Command1.CommandText = "dbo.sp_filterbycat"
Command1.Parameters.Append Command1.CreateParameter("@RETURN_VALUE", 3, 4)
Command1.Parameters.Append Command1.CreateParameter("@catid", 3,
1,100,Command1__catid)
Command1.CommandType = 4
Command1.CommandTimeout = 0
Command1.Prepared = true
RsGenreFilter = Command1.Execute()

help well appreciated on this one desperatelly need a solution

thanks


"Adam R" <adamr (AT) btinernet (DOT) com> wrote

Im trying to do a "RecordCount" on stored procedure that returns a
Recordset
but i keep getting :

Object doesn't support this property or method:

what setting do i have to change to the code that dreamweaver has written
to
get this to work ?

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_artco_STRING
Command1.CommandText = "dbo.sp_filterbycat"
Command1.Parameters.Append Command1.CreateParameter("@RETURN_VALUE", 3, 4)
Command1.Parameters.Append Command1.CreateParameter("@catid", 3,
1,100,Command1__catid)
Command1.CommandType = 4
Command1.CommandTimeout = 0
Command1.Prepared = true
RsGenreFilter = Command1.Execute()