Posted - June 06 2005 : 05:45:17
| Hi, I've go two similar problems with searching multiple criteria with vp-asp;
I have products that are also subcategories of several other categories. When I try to search subcategoryA, SubcategoryB, subcategoryC for a product the results display ALL products in A, B and C. How do I just get it to display products that are ONLY in all three A, B and C?
My products have features X,Y,Z. I want to use 3 drop-down selection boxes to select a product that ONLY matches all three X,Y,Z criteria?
Support tells me I need to edit the SQL in the following 2 subroutines in shopproductcreateSQL.asp
For shopquery.asp: QuerygenerateSQl
For shopsearch.asp: SearchgenerateSQl
I've been trying a few things but not really getting anywhere. Any help or advice would be REALLY appreciated. Thanks.