I don't think you should look at using the client storage variables as a
way of managing hit count. It isn't very accurate and client variables do
not last long enough. If you want to do traffic analyis either plug it in
to your application.cfm (if you must) or do it through some common page
(like a welcome page or when a person logs in).
Adam
-----Original Message-----
From: James Smith [SMTP:[EMAIL PROTECTED]]
Sent: 13 February 2001 17:53
To: CF-Community
Subject: Re: Client Variable Storage
Unless I am missing something you can only specify client variable storage
location by datasource not by table so at the end of the day the only way
to
store them in separate tables is to set up a new datasource for each site
which requires a new database to be set up.
If I am wrong then please say so and let me know where in the
CFAdministrator you set up client variable storage by table and I will be
happy to give it a shot.
--
James Smith
[EMAIL PROTECTED]
Brainbench transcript ID: 822462
http://www.brainbench.com/transcript.jsp?pid=822462
----- Original Message -----
From: "John McCosker" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 3:11 PM
Subject: RE: Client Variable Storage
> have a seperate table for each site, not a seperate database.
>
> -----Original Message-----
> From: James Smith [mailto:[EMAIL PROTECTED]]
> Sent: 13 February 2001 14:57
> To: CF-Community
> Subject: Client Variable Storage
>
>
> OK, here is one for you.
>
> I have set client variables to be stored in a database (MySQL, but that
is
> irelevant) and have come accross a problem I had never noticed before...
>
> The DATA field of the CGLOBAL table stores a hit count, but on a client
> basis not a client/application basis. This means that if I store client
> variables from two applications in the same database the hitcount is a
> total.
>
> Illustration: I visit site1 20 times, I visit site2 20 times, the
hitcount
> stored in the database reads 40.
>
> This makes it practically useless as a hitcount on any site as (although
it
> is unlikely) if one person visits two sites on the server the data
becomes
> irelevant.
>
> I can only think of two solutions to this...
> 1) Use a seperate database for every single site. This is a bit of
overkill
> and adds great complexity to the server.
>
> 2) Store the hit count seperately (as client.site1_hitcount for example).
>
> Is there a better solution or am I going about this totally the wrong
way?
>
> --
> James Smith
> [EMAIL PROTECTED]
> Brainbench transcript ID: 822462
> http://www.brainbench.com/transcript.jsp?pid=822462
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
