asp_databases thread: Conting Results in objrs
Message #1 by "Arsalan" <arsal21@y...> on Mon, 28 May 2001 08:04:50
|
|
i am running a query on MS Access DB and getting results in RS.
i just wanna count the total number of rows that the query has collected
from the database. i.e. i wanted to show the user the number of results
found matching his/her criteria as usually happens in search engines.
how can i do this ?
Message #2 by "Ken Schaefer" <ken@a...> on Tue, 29 May 2001 00:02:40 +1000
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: i am running a query on MS Access DB and getting results in RS.
: i just wanna count the total number of rows that the query has collected
: from the database. i.e. i wanted to show the user the number of results
: found matching his/her criteria as usually happens in search engines.
: how can i do this ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
www.adOpenStatic.com/faq/recordcounterror.asp
and
www.adOpenStatic.com/faq/recordcountalternatives.asp
Cheers
Ken
|