traffic lights

Hey Ray

On that traffic light system on the product results page (attached)
clicking on red or green displays the correct stock items but clicking amber it lists both amber and green (but not all the green)

cheers

Jamie

Maybe try using:

$addSQL = " WHERE (ProductStock - (SELECT Coalesce(SUM(DetailQuantity),0) FROM orders Inner Join orderdetails ON orderdetails.DetailOrderID = orders.OrderID WHERE OrderDate > ProductUpdateDate AND DetailProductID = ProductID)) BETWEEN 1 AND Coalesce(AmberStock,4)";

I'm not sure if the extra parenthesis will help, but it seems like it might.

sorry, I think you mean for me to update the StockAmber rs but unsure of the syntax using the above

Have tried a variety of variations but none work

We updated this in a screen sharing session. We had to update the logic to account for the number of items sold since the last inventory count and account for the amber alert number saved in the database.