Number of rows returned with a select?

Is there a way to grab the number of rows returned in a select?

So say if I have

SQL = "Select * From someDB"
Set RS = DBconn.Execute(SQL)

is there some way to say RS.SOME_COMMAND and have it return the correct number?

I seem to recall doing this before (might have been in PHP though) but I just can't remember how.


Any help would be appreciated,

Darksbane

Yeah from your recordset object:

object.RecordCount

Now if it gives your -1 then read this:

http://www.asp101.com/samples/db_count.asp

You could also do this:

Select count(*) for someDB