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,