RE: # of users logged in

[Marlon Moyer]

Title: # of users logged in

Gary,  try this

 

 select  count(*) visitors
 from   cglobal
 where lvisit > #dateAdd("h",-8,now())#

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Houk, Gary
Sent: Thursday, April 12, 2001 2:12 PM
To: '[EMAIL PROTECTED]'
Subject: # of users logged in

Could someone give me a hand with this - I want to know how many users are logged in to my app using the client.lvisit variable. I want a count of how many people have logged in within the last 8 hours.

select * from cglobal
where lvisit <= 8 hours