?
Solved

Coldfusion Code

Posted on 2008-06-25
3
Medium Priority
?
168 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
This installment of Make It Better gives Media Temple customers the latest news, plugins, and tutorials to make their Grid shared hosting experience that much smoother.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Suggested Courses

615 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