I have a traffic light system that show product performace at basses. This was a finished page until the client wanted to weight the products and the bases. Weightings are between 0 and 1.0 - There are two select boxes on the page that allow you to filter the results EG. Only show me products where the weighting = 1.0 or = .5 etc. You may choose a baseWeighting, productWeighting or a combination of the two.

The values being passed in the select boxes are as illustrated above however there is now a need to include EG where someWeighting <=.5 Or someWeighting >=.5

I am using the FormatNumber function to ensure values are being compared like so 1.0 or .1 or .5 etc. The two IF conditions below work like a treat when there is no < or > involved in the values being compared. When either of these two conditions are asked for they are put into the variables:
1..prodFilter = selected product filter condition
2..baseFilter = selected base filter condition
They are being compared to the weighting values:
1..reviews(4) = productWeighting
2..bases(2) = baseWeighting

The page errors out when either >.5 or <.5 conditions are selected, otherwise it works trouble free. I know why I get the error: You cant run the formatNumber function against a value that has > or < within - I am having a little trouble finding a solution. Here is the start of the statement that detects a filter has been asked for:

IF (prodFilter <> "" AND prodFilter <> "all") or (baseFilter <> "" AND baseFilter <> "all") THEN
   IF (formatNumber("0" & prodFilter,1) = formatNumber("0" & reviews(4),1)) OR formatNumber("0" & baseFilter,1) = formatNumber("0" & bases(2),1) THEN....

Wind is your friend
Matt

__________________
Wind is your friend
Matt

damn, seems so simple. I am about to completely change the design plan of the page to focus on changing the SQL - this causes a problem: I want to show the assessments (traffic lights) base on the user defined conditions as explained above. The reason I still need all the records; there is an average column at the end. Regardless of what results are showing based on user selections I need to show the line average for all items.

Why wouldnt this work (runs trouble free but does not show the correct records):

IF (prodFilter <> "" AND prodFilter <> "all") or (baseFilter <> "" AND baseFilter <> "all") THEN
   IF (formatNumber("0" & prodFilter,1) = formatNumber("0" & reviews(4),1)) OR (baseFilter = "<=.5" AND bases(2) <= ".5" ) OR (baseFilter = ">=.5" AND bases(2) >= ".5" ) THEN....

FYI the two trailing OR conditions is the problem area:
OR (baseFilter = "<=.5" AND bases(2) <= ".5" )
OR (baseFilter = ">=.5" AND bases(2) >= ".5" )

The baseFilter var is equal to "<=.5" and ">=.5"
and bases(2) is equal to ".5"


Wind is your friend
Matt