how do i access the RecordCount pro

[Discord]

how do i access the RecordCount property of a recordset returned by a stored procedure call? any help would be greatly appreciated.

 

[link9]

connectionbject.Execute CommandText, RecordsAffected, Options

is your syntax, so if you have a command that executes the stored procedure:

dim sql
sql = "EXEC spMySproc"

then you need the following:

dim recordsAffected
connectionObject.execute sql, recordsAffected

'this will write the number of rows affected
response.write(recordsAffected)


paul

 

[Discord]

according to microsoft

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcmdexecute.asp

"RecordsAffected does not return the number of records returned by a result-returning query or stored procedure. To obtain this information, use the RecordCount property."

 

[rac2]

var rsGetSomeData = Server.CreateObject("ADODB.Recordset"
rsGetSomeData.CursorLocation = 3; //adUseClient
. . .
rsGetSomeData.Open(myQuery, myConnection);
rsGetSomeData.RecordCount;

 

[Discord]

thank you all for your help. i just won't use the ADODB.Command object.