Instead of using the checkboxes, just set the initial quantity value for the solid and glass shelf, and let the users increase the quantity if they like, a positive quantity would be the same as checking the box, the checkbox just adds an un needed layer of complexity.
...
I changed the checkbox to a hidden field, and this, along with the Qty field, works fine if I am sending it straight to the eCart object like I was originally.
But I need to add a step in-between. So rather than "Add To Cart", I am posting the form to the search and recordset and printing it out as a string that will then be added to the cart as single item later.
But I can't figure out how to filter or trigger the results based on if the Qty boxes have a value or not.
The current Search comparison is:
//comparison list additions
$WADbSearch1->addComparisonFromList("ProductID","hiddenfield","AND","=",1);
Which returns all of the products since they are always true. So I need to add the Qty text field in here some how.
Would I add a comparison to the Search behavior that requires a value of > 0 before it grabs the product ID? If so, how would I do that? Or should I add some kind of WHERE clause to my recordset that is filtered by the Search.
Thanks
Troy