DayOfWeek(Right(ct_time, 10)) gets the date part of the timestamp, the way I
have it is hh:mm YYYY/DD/MM.

I do dump the numbers to see I have a table on my page that shows the numbers
like this

Sun: 4
Mon: 24
Tue: 26
Wed: 22
Thu: 38
Fri: 28
Sat: 8

Total: 150

DayOfWeek(Right(ct_time, 10)) gets the date part of the timestamp, the way I
have it is hh:mm YYYY/DD/MM.

I do dump the numbers to see I have a table on my page that shows the numbers
like this

Sun: 4
Mon: 24
Tue: 26
Wed: 22
Thu: 38
Fri: 28
Sat: 8

Total: 150

What is the data type of the "ct_time" column?

PopcornCoder wrote:
> I do dump the numbers

No, dump the actual query objects:

<cfdump var="#DuringBusinessHours#">
.... etc...

> Varchar and what does the cfdump do?

Generally, dates and time values should be stored in datetime columns, not
varchar.

> what does the cfdump do

It is a useful debugging tool. In this case it will display the actual results
of the query. Not just the totals.
http://livedocs.adobe.com/coldfusion...s/00000239.htm

> Varchar and what does the cfdump do?

Generally, dates and time values should be stored in datetime columns, not
varchar.

> what does the cfdump do

It is a useful debugging tool. In this case it will display the actual results
of the query. Not just the totals.
http://livedocs.adobe.com/coldfusion...s/00000239.htm

DId that and no dice on anything different there

DId that and no dice on anything different there

Since I cannot see the results, I do not have much else to suggest.

Since I cannot see the results, I do not have much else to suggest.

How can I compare the 2 cfdumps to eachother to find the missing ones?