It appears that you don't have any code that runs if any of these conditions
are false:
<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]))
>
Is it possible that all these conditions are true only once per query loop
iteration?
Why not push some output to the screen if the above condition evaluates to
false to see if that's the case?
On Wed, Feb 23, 2011 at 12:38 PM, Adam Bourg <[email protected]> wrote:
>
> 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:342531
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
