Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Coldfusion Code

Posted on 2008-06-25
3
Medium Priority
?
167 Views
Last Modified: 2013-12-24
The code below will display the job number and employee number and the hours on each job, however, if each employee has many jobs then the employee will appear in its row for each job which is fine. I do not want the hours worked to turn up after each job tho, I want a total amount of hours to turn up for each job  in a new column. How can this be done?
<td><cfloop index="ind" from="1" to="#get_fsr.recordcount#" step="1">
#get_FSR.FSR_JobNumber[ind]# - #get_fsr.FSR_EmployeeNumber[ind]# - <br>Worked Hours:#get_fsr.FSR_Work_Time[ind]#
<br>
<cfif ind is not get_fsr.recordcount>
<br>
</cfif>
</cfloop>

Open in new window

0
Comment
Question by:xrayroom
3 Comments
 
LVL 18

Expert Comment

by:Plucka
ID: 21864183
Just store a reference to last code

then say if this code neq last code display total.
0
 

Author Comment

by:xrayroom
ID: 21864323
how could I  write the for this?
0
 
LVL 2

Accepted Solution

by:
dbanttari earned 750 total points
ID: 21865415
Actually, a grouped CFOUTPUT makes this easy:

<table>
<tr>
	<th>Job</th>
	<th>Employees</th>
	<th>Total</th>
</tr>
<cfoutput query="get_fsr" group="FSR_JobNumber">
<tr>
	<td valign="top">
		#get_FSR.FSR_JobNumber#
	</td>
	<td>
		<cfset hours=0>
		<cfoutput>
			#get_fsr.FSR_EmployeeNumber#<br>
			<cfset hours = hours + FSR_Work_Time>
		</cfoutput>
	</td>
	<td valign="top">
		Worked Hours:#hours#
	</td>
</tr>
</cfoutput>
</table>

Open in new window

0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, I was working on some optimization and spam-stopping techniques when I encountered Ben Nadel's post to reduce spam feature using Math (http://www.bennadel.com/blog/197-How-I-Stop-Spammers-On-My-ColdFusion-Blog.htm). While this method is not o…
This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question