Using ASP and Sql Server Storedprocedure. not abel to MoveFirst in Recordset.
Posted on 2004-10-28
I am using Sql Server 2000.
i am not abel to movelast and movefirst in the Recordset.
CREATE PROCEDURE [veenaimvsql].[AllFlashCards] AS
select ecid,smallcard,Hits from ecards where flash='True' order by ecid desc
objCmdECards.ActiveConnection = stringConn
objCmdECards.CommandText = "FlashCards"
objCmdECards.CommandType = adCmdStoredProc
Set objCmdECards = Nothing
If i give ObjRsFlashCards.Movefirst
Operation was canceled. - is the Error result in that line.
i am not abel to get the recordcount also if i use like this.
Recordcount Returns -1.
how can i do movefirst and get the Recordcount value.