On Thursday, June 22, 2000, Gina Shillitani <[EMAIL PROTECTED]> wrote:
>We're looking at about 86,000 hits per day on the reporting server, which is
>where I need to collect this information. I'm trying to figure out if there
>is a way I can track a single user through each visit to the site and record
>the entire session to one record in the table. Example, the user with token
>XYZ requested a.cfm, b.cfm?var=keyword, c.cfm?var=keyword&var2=5, on
>6/25/2000 at 8:56 AM and spent 15 minutes total on the site. This would be
>preferable to recording single page hits and I do need to record any
>variables that are passed to individual pages.
As others have mentioned you could record each page view by using the application.cfm
and the cgi variables. To get to the summary data you are looking for you could run a
scheduled event at the end of each day that queries the data for individual visits and
loads the results in a summary table and when completed clears the 86,000 records out
of the log file.
--
Lee Surma
Public Radio International
[EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.