Here's a bit of the code if you need to see it.

<!--- Setting an array of date ranges ---> 
<cfset validDateRange=ArrayNew(1)>
<cfset ArrayAppend(validDateRange, "0")> <!--- Index 1 ---> 
<cfset ArrayAppend(validDateRange, "15")> <!--- Index 2 ---> 
<cfset ArrayAppend(validDateRange, "30")> <!--- Index 3 ---> 
<cfset ArrayAppend(validDateRange, "60")> <!--- Index 4 ---> 
<cfset ArrayAppend(validDateRange, "90")>  <!--- Index 5 ---> 

<!--- Defining an empty class for our table row ---> 
<cfset daySet=""> 

<!--- a Continue(); function; setting a default value of false ---> 
<cfset continueL=false>

<!--- The loop that dumps the database --->  
<cfloop query="certs">
    
        <cfoutput>
        
                
        
        
        
<cfloop from="1" to="4" index="listValue">

    <!--- has this row already been run? a sort of Coldfusion Continue(); ---> 
   <!--- <cfif continueL EQ False> --->   
          <!--- EXPIRES IN x days but greater then y --->
          <!--- Does expire in x days but not less then y? ---> 
            <cfif 
            ((adultExp gt validDateRange[listValue]) AND (adultExp LTE 
validDateRange[listValue+1])) OR 
            ((kidExp gt validDateRange[listValue]) AND (kidExp LTE 
validDateRange[listValue+1]) ) OR
            ((frpExp gt validDateRange[listValue]) AND (frpExp LTE 
validDateRange[listValue+1])) OR
            ((aExp gt validDateRange[listValue]) AND (aExp LTE 
validDateRange[listValue+1])) OR
            ((aidExp gt validDateRange[listValue]) AND (aidExp LTE 
validDateRange[listValue+1])) OR
            ((eExp gt validDateRange[listValue]) AND (eExp LTE 
validDateRange[listValue+1])) OR
            ((waterExpt gt validDateRange[listValue]) AND (waterExpt LTE 
validDateRange[listValue+1])) OR
            ((bloodExp gt validDateRange[listValue]) AND (bloodExp LTE 
validDateRange[listValue+1])) OR
            ((oxyExp gt validDateRange[listValue]) AND (oxyExp LTE 
validDateRange[listValue+1])) OR
            ((lifeExp gt validDateRange[listValue]) AND (lifeExp LTE 
validDateRange[listValue+1])) OR
            ((wildExp gt validDateRange[listValue]) AND (wildExp LTE 
validDateRange[listValue+1]))
            >
                <cfswitch expression="#validDateRange[listValue]#">
                    <cfcase value="0"> <cfset daySet="class='tr15'"> <cfset 
continueL=true></cfcase>
                    <cfcase value="15"> <cfset daySet="class='tr30'"> <cfset 
continueL=true></cfcase>
                    <cfcase value="30"> <cfset daySet="class='tr60'"> <cfset 
continueL=true></cfcase>
                    <cfcase value="60"> <cfset daySet="class='tr90'"> <cfset 
continueL=true></cfcase>
                    <cfdefaultcase> <cfset daySet=""> <cfset 
continueL=true></cfdefaultcase>
                </cfswitch>
                
                
                
                
                                <!--- If it's true it returns to the loop with 
the #daySet# veriable and we use that to define the class -- That way if it's 
false it's a simple TR, but if it's true we get a class style --->
                
                <!--- Code has been run time to set to true an go to the next 
row --->     
                <cfset continueL=true>
        
        </cfif> <!--- Closing the date loop, inner --->
 
   <!---</cfif>---><!---  End Continue(); --->

</cfloop><!--- Ends the array loop --->  
        
        <!--- a Continue(); function ---> 
        <cfset continueL=false>
        
        
        
                <tr #daySet#>

<!--- lots of table data output, then we close ---> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342529
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to