Custom Search - sql query
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=2140
Printed Date: 22-July-2025 at 5:54am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Custom Search - sql query
Posted By: austcold
Subject: Custom Search - sql query
Date Posted: 14-November-2008 at 1:19am
I have upgraded to the latest Product Cart version 3.5.
I created a custom search field called"Model Number" and enter a model number for that product.
I am trying to create a drop menu using the "model number data" as dynamic data and filtered by the brand. The reason for this is that the list of models for all brands has to many entries to sort through.
I have worked out that I can create a drop menu for all model numbers by using the table "pcSearchData" selecting the "pcSearchDataName" and filtering it with "idSearchField" =1 (which is the ID key for my custom field "Model"), becouse all custom field data is in the same table and field.
The SQL query looks like this,
SELECT pcSearchDataName
FROM dbuser.pcSearchData
WHERE idSearchField = 1
? How can I filter further using the "Brand"
? can it be done with just a query or do tables need to be modified?
-------------
www.austcoldindustries.com.au
|
Replies:
Posted By: austcold
Date Posted: 16-November-2008 at 6:03pm
? Is there a tool to track the "pcdataName" field relationship back to the "products" Table.
? Does ProductCart have this information available to us.
If I new the path I should be able to create the query without to much trouble, I think?
Currently trying "SQL Maestro" which appears to be pretty good with mssql databases.
Please help.
-------------
www.austcoldindustries.com.au
|
Posted By: benpate
Date Posted: 11-December-2008 at 9:05pm
You should be able to do this with just a query. A stored procedure with two variables should work.
-------------
http://www.web1seo.com - ProductCart SEO - Resellers and Affiliates welcome
|
|