Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Subsequent Results Pages Showing Code

Subsequent Results Pages Showing Code

Thread began 9/26/2012 1:00 pm by reiter303441179 | Last modified 10/09/2012 12:17 pm by reiter303441179 | 2800 views | 16 replies

9/27/2012 9:51 amJason ByrnesWebAssist

I'm trying to filter the manufacturers so only manufacturers populate who have products in the category being viewed

how are manufacturers linked to products in your database?

using different types of joins in your query can achieve the results you are after to join the manufacturers and products table together.

Using a inner join will only return a result if there is a march in both tables. See this page for more details on join queriers:
Join_(SQL)

for details on clearing the search filter, see the following thread:
showpost.php?p=99028&postcount=2

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.