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>&nbsp;#Results#
        <cfelseif #vComply# eq "Concurrent">
            <font color="990000">#vComply#</font>&nbsp;#Results#
            <cfelse>
        <font color="FF0000">#vComply#</font> &nbsp;#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

ethanjohnsonsAsked:
Who is Participating?
 
gdemariaConnect With a Mentor Commented:

Have an outer table that shows the vDisplya types
 and then inner table that displays the details of the record ..

<table>
 <tr>
   <cfloop query="RstDisplay>
   <td>#vDisplay#</td>
   </cfloop>
 </tr>
 <tr>
   <cfloop query="RstDisplay>
    <td>
     <table>
       <tr><td>#theAssociateID</td></tr>
       <tr><td>#Lname</td></tr>
       <tr><td>#Dept</td></tr>
       <tr><td>#HireStatus</td></tr>
     </table>
   </td>
   </cfloop>
  </tr>
</table>
       
     
0
All Courses

From novice to tech pro — start learning today.