Custom Search - sql query

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply Topic: Custom Search - sql query 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

austcold Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29-May-2008 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote austcold Report Post Thanks(0) Quote Reply 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

benpate Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 15-February-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote benpate Report Post Thanks(0) Quote Reply 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.
	ProductCart SEO - Resellers and Affiliates welcome