• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

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

0
ethanjohnsons
Asked:
ethanjohnsons
1 Solution
 
gdemariaCommented:

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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now