I think I have a "can't see the forest through the trees" type of problem.
I have an access database table that logs the timing of an http request many times during the day. So, the table content looks like this: 717 Pass 7656 ms 04/19/02 2:30:32 PM 716 Pass 1672 ms 04/19/02 2:20:58 PM 715 Pass 1782 ms 04/19/02 2:10:58 PM 714 Pass 5281 ms 04/19/02 2:01:02 PM The first column is just an incremental counter. What is not obvious from the above table is how the date and time fields work. Date/Time are ONE field in the access table, using the date/time field type. I output them in CF to display separate columns using Date() and Time(). What I want to do is a histogram by hour of the day that depicts the average access time (second column) since the inception of the test. I am not concerned with the date, but rather the hour of the day. Soooo, what I want is the following: 12 AM Avg Time 1 AM Avg Time 2 AM Avg Time 3 AM Avg Time 4 AM Avg Time 5 AM Avg Time 6 AM Avg Time 7 AM Avg Time .. .. .. My hunch is to use a CFLOOP with the #hour(datefield)# approach. Is this the best way?? ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
