This content has been marked as final. Show 3 replies
If the date hired never changes, you can do this sort of thing.
<cfoutput query="yourquery" group="name">
But if the same person can have more than 1 hire date, you'll need a totally different approach.
Any one else have any ideas??
Your problem is that when a person has multiple records, you are not outputting the tags you need to start a new row and have a table cell in the name column. That throws your columns out of whack.
You can fix this by setting an empty string value before you start the nested CFOUTPUT tags, then setting that value to the table tags for subsequent loops.
Something like this:
<CFSET rowstart = "">
<td align="center"><cfif #Terminated# EQ 0>Active<cfelse>Inactive</cfif></td>
<td align="center"><cfif #terminated# EQ 0>--<cfelse>#DateFormat(lastActionDate, 'mm/dd/yyyy')#</cfif></td>
<CFSET rowstart = "<tr class='#Class#'><td></td>">
The first time around, rowstart is blank. But for the second and subsequent records in the group, it displays the tr and td tags.