I've been using ASP for about a week now. It's great, pretty straight-forward and easy with a bit of reading.

However, I've now got to a point where I realise that ASP isn't as simple as I thought. I've encountered the data access from Oracle problem.

I can connect. I can create and open a recordset. I can get data out of my recordset onto the browser. The problem I have is that I have written my code in such a way that no matter what the SQL query is, ASP will count the fields and rows and create an appropriately sized table for the data.

Except I can't count the rows.

It's a long introduction to this question but here it is:
HOW CAN I COUNT THE ROWS IN A RECORDSET???

I am using a ADODB connection with an adOpenDynamic cursor. Maybe it has something to do with that? I don't know.