So to get this to work with the client variables table I'll need
something like this:
Select count(cfid)
From cglobal,cdata
Where lvisit gt #(dateadd("m",-20,now())#
And cglobal.cfid = cdata.cfid
And cdata.app = #myappname#
Easy. I initially thought that I would have to create a list of cfid's
on my site then use that list when qurerying the cglobal table. Then I
looked in the cdata table and it conveniently gives us the app field.
Caching this query to about 20 mins should make it pretty fast too.
Giles Roadnight
http://giles.roadnight.name
-----Original Message-----
From: Taz -=TT=- [mailto:chris@;cfmaster.co.uk]
Sent: 07 November 2002 12:32
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Online Users
> does the client db store usernames etc...?
sort of, it sticks in all the crap in the client scope, but that's not a
great way of accessing it because its in one column.
but it stores cfid, so you can compare that with your app db (so long as
you've stored cfid in your db too)
Taz
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
