VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 search multiple criteria - sql query
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

11 Posts

Posted - June 06 2005 :  05:45:17  Show Profile  Reply with Quote
Hi, I've go two similar problems with searching multiple criteria with vp-asp;

1. Shopsearch.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?

2. Shopquery.asp
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.


Starting Member

11 Posts

Posted - June 06 2005 :  08:55:25  Show Profile  Reply with Quote
Phew. Got it working ok now.


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000