Data Assist Search

[deno1965]

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

[Ray Borduin]

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.

[deno1965]

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.

[Ray Borduin]

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.