If an object that you've dispatched to is a collection, then you can find the total amount of elements in the collection with $comval(<col>,0), although I must say, mIRC still doesn't always do this.
Often you can issue the count property like:
!.echo -q $com(<obj>,count,2 or 3)
echo -a $com(<obj>).result
Regarding the recordset, you're supposed to dispatch to a fields collection, something like:
!.echo -q $com(objset,fields,2,dispatch* fields)
Then:
if ($com(fields)) echo -a Total: $comval(fields,0)
or:
if ($com(fields)) { !.echo -q $com(fields,count,3) | echo -a Total: $com(fields).result }
This is of course untested, I have no motivation to get into ADO atm.
For a list of open objects:
alias listcoms var %i = 1 | while ($com(%i) != $null) { echo -a %i - $ifmatch | inc %i }
Anything you want to know about ADO, you will find at
MSDN, more specifically take a look at the
ADO object model. Check there before asking questions here, because you will find everything you need to know there.
I'd give you more help myself, but these days I must focus on uni instead of mIRC.
Btw, don't forget there are also
DLL's to control databases. I mention it because I remember vaguely reading about there being a huge memory leak when using the mysql COM objects.