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
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 V6.50 deluxe: Search by Suppliers
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

goshen
VP-ASP New User

132 Posts

Posted - March 05 2007 :  21:23:28  Show Profile  Reply with Quote
Hi,
I am asking this question here because I got absolutely no response in the other section and this is not encouraging.

Is there a way for customers to search by suppliers in addition to searching products by categories? The idea is to give customers the option to search for products from a drop down list of suppliers. I can see that there is a supplier id in the products table in addition to the supplier table. So I will expect that there is either an INNER JOIN sql code somewhere that is available.


If so please how can I turn this on in VPASP 6.X

If not, does anyone know what sub routine I need to add and where to right.

I still want the output to display in the shopdisplayproducts.asp as with seraching by products.

Many thanks
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000