Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Blue Sky Search won't return results from database

Blue Sky Search won't return results from database

Thread began 8/04/2015 1:14 pm by tmcbinc99963 | Last modified 8/11/2015 1:16 pm by tmcbinc99963 | 1905 views | 9 replies

8/05/2015 12:16 pmRay BorduinWebAssist

They can use different tables, but they have to refer to the correct associated (joined) field that represents the foreign key. The ItemID column is the unique ID for the items table, and the catSearch select is populated with the unique ID of the categories table. There has to be a joined column in the Items table that identifies the category the product is in that is used to compare against the category id passed from the search.

Did this help? Tips are appreciated...

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.