Make your own stats table with these fields:
STATS
FuseAction
Count
In your OnRequestEnd.cfm page, do this:
<CFQUERY name="GetFuseStats">
SELECT Count from Stats where FuseAction = '#rattributes..fuseaction#'
</cfquery>
<CFIF GetFuseStats.RecordCount GT 0>
<CFQUERY name="updateStats">
UPDATE Stats SET Count = Count + 1
WHERE FuseAction = '#rattributes.fuseaction#'
</cfquery.
<CFELSE>
<CFQUERY name="InsertStats">
INSERT INTO Stats (FuseAction, Count)
Values ('#rattributes.fuseaction#',1)
</cfquery.
<cfelse>
If you pre-loaded this table with all possible fuseactions, then you could
eliminate that first SELECT query, and just do the update every time.
At 10:41 AM 2/14/01, Jason Egan wrote:
>A client is mad about server stats and with our fusebox app they can't see
>specifically what pages are being hit... is there any software out there to
>track this?... all that I have see so far just adds hits to the index.cfm
>page time and time again... never any included or 'sub-pages'...
>
>Thanks for the input.
>
>je
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
