Solved

Layout with cfif

Posted on 2007-03-24
1
175 Views
Last Modified: 2013-12-24
 <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
Comment
Question by:ethanjohnsons
1 Comment
 
LVL 39

Accepted Solution

by:
gdemaria earned 500 total points
ID: 18790123

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

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question