Counting Recordset problem

[Juppo]

Hi
Im trying to make a user online counter (to count everyone viewing the site). Im a new to sql so obviously having trouble with things. In the internet database Im using a tabel called PPLONLINE with a field again called PPLONLINE. All I seem to be getting is -1 for a value even though there is alot. Can someone help me out?

<%
	DataSource = &quot;Driver={Microsoft Access Driver (*.mdb)}; 
        DBQ=&quot; & site_root & &quot;interdata/internet.mdb&quot; & &quot;;&quot;
	Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;)
        sql = &quot;select COUNT(PPLONLINE) from PPLONLINE&quot;
	rs.Open sql, DataSource 
		
NumberOfPplOnline = rs.RecordCount
	
	rs.Close
	Set rs= nothing
%>

 

[swampBoogie]

NumberOfPplOnline = rs(0)

 

[Juppo]

Cheers that works great, but why?
Are you saying count rs from (0)? start at record 0 ?

 

[swampBoogie]

Your query will only return one record with one result column. You can index the rs collection to get individual fields starting at 0.

rs.recordcount contains the number of records in the recordset. -1 means that the number of records is unknown.

 

[Juppo]

ah, ok thanks swampBoogie