Recordset.RecordCount

[damann]

Does anyone know why Recordset.RecordCount always outputs a value of -1? Please let me know, it's giving me a headache...

 

[onpnt]

If your provider does not support the count property a value of -1 will always be returned. I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.

 

[onpnt]

You can also check this site and example for why this happens.

http://www.codefixer.com/tutorials/recordcount.asp

I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.

 

[arya009]

Try to open your Recordset cursor location as clint side before rs.open statement

rs.CursorLocation = adUseClient

 

[goatstudio]

Take a look at the example here:

http://www.asp101.com/samples/viewasp.asp?file=db_count.asp

------------------
Freedom is a Right

 

[adamsoderqvist]

No. You have to set the cursor to "adOpenKeyset" when opening the database!

 

[zKaleb]

If you use it in ASP, for better perfomance use adOpenStatic and if you are not going to change the data, make it ReadOnly in your LockType, your cursor location got nothing to do.

Believe me, is the better performance you will get besides a Firehose (ForwardOnly and ReadOnly)