Solved

Coldfusion Code

Posted on 2008-06-25
3
156 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 250 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

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 …
I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now