0

Can someone tell me why this code is not displaying the "time" field in the table? I cannot figure it out.

<tr>

<CFQUERY NAME="getAllTechsWeeklyActivity" DATASOURCE="VEHSALES">							
SELECT date, time, DatePart(ww, date), datepart(dw, date) AS weekday
FROM service_tech_activity 
WHERE DatePart(ww, date) = DatePart(ww, '#DateFormat("#editdate#", "yyyy-mmm-dd")#')
AND DatePart(yyyy, date) = DatePart(yyyy, '#DateFormat("#editdate#", "yyyy-mmm-dd")#')
GROUP BY date, time, DatePart(ww, date), datepart(dw, date)
</CFQUERY>        				
  
  <CFSET sunday = 0>
  <CFSET monday = 0>
  <CFSET tuesday= 0>
  <CFSET wednesday = 0>
  <CFSET thursday = 0>
  <CFSET friday = 0>
  <CFSET saturday = 0>
  <CFSET total = 0>    
                       
<CFLOOP QUERY="getAllTechsWeeklyActivity">
<cfif #weekday# is 1>					
<cfset sunday = #DecimalFormat(time)#>						
<cfelseif #weekday# is 2>		                                
<cfset monday = #DecimalFormat(time)#>          
<cfelseif #weekday# is 3>					
<cfset tuesday = #DecimalFormat(time)#>						
<cfelseif #weekday# is 4>					
<cfset wednesday = #DecimalFormat(time)#>						
<cfelseif #weekday# is 5>
<cfset thursday = #DecimalFormat(time)#>						
<cfelseif #weekday# is 6>
<cfset friday = #DecimalFormat(time)#>						
<cfelseif #weekday# is 7>
<cfset saturday = #DecimalFormat(time)#>						
</cfif>
<cfset total = DecimalFormat(total + #time#)>
</CFLOOP>
			  			  
<td align="center" valign="top" width="10%" bgcolor="#61676B" class="tabletext"><STRONG>#monday#</STRONG></td>				
<td align="center" valign="top" width="10%" bgcolor="#61676B" class="tabletext"><STRONG>#tuesday#</STRONG></td>				
<td align="center" valign="top" width="10%" bgcolor="#61676B" class="tabletext"><STRONG>#monday#</STRONG></td>				
<td align="center" valign="top" width="10%" bgcolor="#61676B" class="tabletext"><STRONG>#wedneday#</STRONG></td>				
<td align="center" valign="top" width="10%" bgcolor="#61676B" class="tabletext"><STRONG>#friday#</STRONG></td>				
<td align="center" valign="top" width="10%" bgcolor="#61676B" class="tabletext"><STRONG>#saturday#</STRONG></td>				
<td align="center" valign="top" width="15%" bgcolor="#61676B" class="tabletext"><strong>#total#</strong></td>
						        
</tr>

Edited by Ezzaral: Added code tags. Please use them to format any code that you post.

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by arrgh
0

Basically, at the end of the code snippet where #monday#, #tuesday#, etc. is displayed - it isnt displaying the "time" value coming back from the database. I am not sure what I am missing.

Thanks,

0

No offense but that query is terribly inefficient. Yes, you can do this the long way (with CF code). But most db's have far more efficient ways to calculate sums for a set of 7 values.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.