How about something roughly like
<cfloop ...>
<table>
<tr>
<td>#job#</td>
<td>#costcode#</td>
<Cfloop index="i" from="1" to="31">
<td>
<cfif datepart("d",startDate ) eq i>
#hours#
</cfif>
</td>
</cfloop>
</tr>
</table>
</cfloop>
-----Original Message-----
From: Larry Lyons [mailto:[EMAIL PROTECTED]]
Sent: 18 March 2002 15:41
To: CF-Talk
Subject: Second Post: Problems formatting output
Hi all,
Since I didn't get much of a response the last time I posted this, and being
the complete unreconstructed optimist that I am I thought I'd try again:
I'm working on a timesheet app. This is the record set that's returned from
the stored procedure:
Direct_Charge Job CostCode startDate row_Number Col_Number
Hours
1 Whatever 001-002 GA 2002-02-01 1 1
8
1 Whomever 001-002 GA 2002-02-01 2 4
1
1 Whatever 001-005 CA 2002-02-01 1 5
3
0 Leave 010-001 LV 2002-02-01 1 2
8
0 Vacation 010-002 VC 2002-02-01 2 11
8
0 Training 006-001 TN 2002-02-01 3 12
8
I need to get the output into something like the following formatting
(assuming here that the timesheet starts on the first of the month):
Direct Charges:
Day of the Month
Job CostCode 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Whatever 001-002 GA 8 3
Whomever 001-002 GA 1
Indirect Charges:
Day of the Month
Job CostCode 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Leave 010-001 LV 8
Vacation 010-002 VC 8
Training 006-001 TN 8
Any suggestions and/or help would be really appreciated. I am tearing my
hair out on this one.
thanks,
larry
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
