I'm not sure it can even be done.
After I output it I then have to put conditional formating.
http://airchathams.selous.nzoffice.com/roster/rosterheaderpage2.htm
Some people have two duties Mon 9th Oct @ Thur 19th Oct
(confusing to output)
When output the days with only one duty are repeated which I
dont want.
I need maybe conditional code.
Is there a better way of doing this or am I on the right
track
Thankyou
<body>
<table id="mytable" cellspacing="0" summary="">
<caption>Fortnightly Roster</caption>
<tr>
<th scope="col" abbr="Configurations"
class="nobg"></th>
<cfoutput>
<cfloop query="Date">
<th scope="col" abbr="Dual 2.5"
colspan="3">#DateFormat(Date.DFRDate,'DDD')#<br>
#DateFormat(Date.DFRDate,'DD-MMM')#</th>
</cfloop>
</tr>
<cfloop query="crew">
<cfset tisCrew = Crew.CrewID>
<cfset rownumber = #currentrow#>
<tr>
<td class="spec" rowspan="4">#tisCrew#</td>
<cfloop query="date">
<cfif structKeyExists( fly, "#tisCrew#|#DFRDate#" )>
<CFSET startduty = #structFind( fly,
"#tisCrew#|#DFRDate#" )#>
<CFSET dutytype = #structFind( dutytest,
"#tisCrew#|#DFRDate#" )#>
<CFSET aa =date.currentrow>
<td rowspan="2">#dutytype#</td>
<td><a href="styles.css?num =
#rownumber#">X</a></td>
<td>#TimeFormat(Startduty,'HHmm')#</td>
<cfelse>
<td rowspan="2"> </td>
<td> </td>
<td> </td>
</cfif>
</cfloop>
</tr>
<tr>
<cfloop query="date">
<cfif structKeyExists( fin, "#tisCrew#|#DFRDate#" )>
<CFSET endduty = #structFind( fin, "#tisCrew#|#DFRDate#"
)#>
<CFSET aa =date.currentrow>
<td><a href="styles.css">X</a></td>
<td>#TimeFormat(endduty,'HHmm')#</td>
<cfelse>
<td> </td>
<td> </td>
</cfif>
</cfloop>
</tr>
<cfloop query="date">
<cfif structKeyExists( fly2, "#tisCrew#|#DFRDate#" )>
<CFSET startduty = #structFind( fly2,
"#tisCrew#|#DFRDate#" )#>
<CFSET dutytype = #structFind( dutytest,
"#tisCrew#|#DFRDate#" )#>
<CFSET aa =date.currentrow>
<td rowspan="2">#dutytype#</td>
<td><a href="styles.css?num =
#rownumber#">X</a></td>
<td>#TimeFormat(Startduty,'HHmm')#</td>
<cfelse>
<td rowspan="2"> </td>
<td> </td>
<td> </td>
</cfif>
</cfloop>
</tr>
<tr>
<cfloop query="date">
<cfif structKeyExists( fin2, "#tisCrew#|#DFRDate#" )>
<CFSET endduty2 = #structFind( fin2,
"#tisCrew#|#DFRDate#" )#>
<td><a href="styles.css">X</a></td>
<td>#TimeFormat(endduty2,'HHmm')#</td>
<cfelse>
<td> </td>
<td> </td>
</cfif>
</cfloop>
</tr>
</cfloop>
</table>
</cfoutput>
</body>