ethanjohnsons
asked on
Layout with cfif
<cfoutput query="RstDisplay">
<tr bgcolor="CCCCFF">
<td>#TheAssociateID#</td>
<td>#Lname#, #Fname#</td>
<td>#Dept#</td>
bla ....
<td>#HireStatus#</td>
<td>
<cfif #vComply# eq "Compliant">
<font color="0000FF">#vComply#</ font>  ;#Results#
<cfelseif #vComply# eq "Concurrent">
<font color="990000">#vComply#</ font>  ;#Results#
<cfelse>
<font color="FF0000">#vComply#</ font> #Results#
</cfif>
</cfoutput>
This output gives the "basic" layout where all rows are under the columns specified.
What I like to have is to divide the layout into three sub-categories based on the #vComply# with cfif, and display like below:
Compliant Concurrent Non-Compliant
<td>#TheAssociateID#</td> <td>#TheAssociateID#</td> <td>#TheAssociateID#</td>
<td>#Lname#, #Fname#</td> <td>#Lname#, #Fname#</td> <td>#Lname#, #Fname#</td>
<td>#Dept#</td> <td>#Dept#</td> <td>#Dept#</td>
bla .... bla .... bla ....
<td>#HireStatus#</td> <td>#HireStatus#</td> <td>#HireStatus#</td>
Any ideas, please.
thx much
<tr bgcolor="CCCCFF">
<td>#TheAssociateID#</td>
<td>#Lname#, #Fname#</td>
<td>#Dept#</td>
bla ....
<td>#HireStatus#</td>
<td>
<cfif #vComply# eq "Compliant">
<font color="0000FF">#vComply#</
<cfelseif #vComply# eq "Concurrent">
<font color="990000">#vComply#</
<cfelse>
<font color="FF0000">#vComply#</
</cfif>
</cfoutput>
This output gives the "basic" layout where all rows are under the columns specified.
What I like to have is to divide the layout into three sub-categories based on the #vComply# with cfif, and display like below:
Compliant Concurrent Non-Compliant
<td>#TheAssociateID#</td> <td>#TheAssociateID#</td> <td>#TheAssociateID#</td>
<td>#Lname#, #Fname#</td> <td>#Lname#, #Fname#</td> <td>#Lname#, #Fname#</td>
<td>#Dept#</td> <td>#Dept#</td> <td>#Dept#</td>
bla .... bla .... bla ....
<td>#HireStatus#</td> <td>#HireStatus#</td> <td>#HireStatus#</td>
Any ideas, please.
thx much
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.