>That is definitely possible and the method of display you suggested
>seems good to me. A graph would be a nice touch. The decision of how
>best to display the data might rest with the person who has to view
>it.
>
>-Mike Chabot
>
>On Sat, May 17, 2008 at 10:34 PM, Toby King <[EMAIL PROTECTED]> wrote:
>>
OK thanks
I have now got the records extracted from the database.
Have used this code but am not getting the results I am hoping for.
This is how the starttime looks in the database - 2008-05-16 22:27:31
<cfquery name="qChartData" datasource="#request.db_dsn#"
username="#request.db_login#" password="#request.db_pwd#">
select jobid, j.shiftid, j.personid, roomid, paymentmethodid, starttime, name
>From tbl_jobs j, tbl_shifts s, tbl_personaltr painers
where j.shiftid = s.shiftid AND
j.personid = p.personid AND
s.shiftid = "F0CB2A8E-16-05-08"
AND (j.bookingstatus = 2 OR j.bookingstatus = 3)
order by starttime
</cfquery>
<cfset ws_starttime eq 0>
<cfloop query="qChartData">
<cfif qChartData.starttime gt "18:00:00">
<cfset jobctr1 = jobctr1 + 1>
</cfif>
<cfif qChartData.starttime gt "19:00:00">
<cfset jobctr2 = jobctr2 + 1>
</cfif>
<cfif qChartData.starttime gt "20:00:00">
<cfset jobctr3 = jobctr3 + 1>
</cfif>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305579
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
