getting RecordCount = -1

[Ankur Bakliwal]

Hello Friends, I have a problem with recordsets. I m getting Rs.RecordCount = -1 while calling a store procedures here is code - Set cmd = Server.CreateObject("ADODB.Command") Set rs = Server.CreateObject("ADODB.RecordSet") cmd.ActiveConnection = myCon cmd.CommandText = "SP_Name" cmd.CommandType = 4 cmd.CommandTimeout = 300 cmd.Parameters.Append cmd.CreateParameter("@par1",20,1,10,1) cmd.Parameters.Append cmd.CreateParameter("@par2",20,1,10,1) cmd.Parameters.Append cmd.CreateParameter("@par3",20,1,10,20) cmd.Parameters.Append cmd.CreateParameter("@par4",20,1,10,Null) Rs.CursorLocation = 3 Rs.LockType = 1 Rs.CursorType = 3 Set Rs = cmd.Execute Response.Write "
RecordCount = " & Rs.RecordCount pls give some usefull solution. Thanks, Ankur Bakliwal

[andyharman]

The -1 means the database driver does not support record-counts for record sets. A quick way of achieving a record count is to use the recordset GetRows() method to extract the data into a two-dimensional array. Then you can do Ubound(arr, 2) to get the number of elements in the 2nd dimension. Regards Andy