https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 00:57:18 +0000 Thu, 11 Dec 2008 21:05:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2140 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/custom-search-sql-query_topic2140_post7780.html#7780 Author: benpate
Subject: 2140
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.
]]> Thu, 11 Dec 2008 21:05:49 +0000 https://forum.productcart.com/custom-search-sql-query_topic2140_post7780.html#7780 https://forum.productcart.com/custom-search-sql-query_topic2140_post7395.html#7395 Author: austcold
Subject: 2140
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.
]]> Sun, 16 Nov 2008 18:03:09 +0000 https://forum.productcart.com/custom-search-sql-query_topic2140_post7395.html#7395 https://forum.productcart.com/custom-search-sql-query_topic2140_post7383.html#7383 Author: austcold
Subject: 2140
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?

]]> Fri, 14 Nov 2008 01:19:24 +0000 https://forum.productcart.com/custom-search-sql-query_topic2140_post7383.html#7383