Search on select field
Posted on 2007-10-03
I have the following query which is working great, I added a select menu (cats_Info) to the previous page where the list="#editfields#" are selected. How can I add to my query below to show only the records that are associated with the select menu value I selected? The select menu is not required so if no slection is made I just run the query below as it is currently.
<cfquery name="GetProds" datasource="GH234" cachedwithin=#CreateTimeSpan(0,0,30,0)#>
<CFLOOP index="field" list="#editfields#">
FROM Products, ProductMatrix, Cats
WHERE Products.ProductID = ProductMatrix.ProductID