I have used the RecordCount property in the Global.asa file but it doesn't work; returning -1 value. Does anyone can help me please?

Many thanks

__________________
Mr. Sokha Eap
Webmaster
UNDP Cambodia

I am not sure what the Global.asa file has to do with this. Are you creating an ADODB.Recordset? Is that what the RecordCount property is referring to?

If so, make sure you open the Recordset in such a way that it supports the RecordCount. Not every Recordset does that. For example, a Read-Only, Forward-Only Recordset will always return -1 as the RecordCount.

Take a look here: http://www.adopenstatic.com/faq/recordcounterror.asp to see how you can fix this. Also, make sure you check out the alternatives to RecordCount here: http://www.adopenstatic.com/faq/reco...ternatives.asp.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Are you simply trying to get a record count of a running recordset? Try including something in your recordset like...

sql = "SELECT Count(Field1) as RecordCount, Field2, Field3 FROM Table"

and so on.