Data Assist Search

Hi,

I see some idiots are spaming the website, takes all kinds. In any case to what were here for. When you use the search wizard it ask for a recordset. Does this mean that all the products need to be in 1 table for this to work correctly?

Thanks

They have to be in 1 Recordset... but you can use JOINS and UNION statements to add more than one table to a recordset.

If you are using more than one Recordset, you can apply the same search to muliple recordsets as well by applying the Search sever behavior more than once on the page.

Hey Ray,

All I really want is to put a regular search box on all my pages and have a keyword search from any page and display the results in another page. (Like most websites) I'm having problems setting this up. The form is on my pages, I told the wizard multiple columns from 1 recordset to 1 form field, each with a keyword setting and a get a error.

Fatal error: Call to undefined function setquerybuildersource() in C:\xampp\htdocs\DragonThemes\search.php on line 107, I can't take this out either, I tried to see what would happen. I don't see it on the search page I downloaded.

What version of DataAssist do you have installed?

If you run the wizard and get a search -> results page working, you can always cut and paste that search form onto every other page in your site and it will still work.