How to revise Data Assist Search page form items

After five DW crashes and two computer restarts, I was able to create a basic search, results, detail page set.

I don't see where to edit the search form. Reopening the wizard only creates new pages with new settings.

The edits I would like to make are:

Prod_search.php: One field for all searches, rather than different text fields for each Db column

Prod_results.php: Have the search return a Product Type from a related Db rather than the numerical Foreign Key

Thanks

The wizard cannot be re-entered to edit created pages. You can either make the changes on the pages in dreamweaver after or delete and re-create the pages.

You can delete all but one of the search fields and then edit the DataAssist Search server behavior to use the one remaining field to search all of the colums.

To display the related field value, you would edit the recordset and add an INNER JOIN to bring the value from the related table into the recordset so you can display it on the page.

I've adapted the multiple text field WA Search down to one text field on the referenced page below.

Tried editing the WA DataAssist and WADAProd record sets so one field would search the whole recordset, but no luck on either server behavior.

Not even sure which is supposed to be edited or how.

Thanks

It looks like you did it correctly. Whatever you type in the field on the search page should return results if found in any of these fields: "ProdImage", "ProdSubhead", "ProdDesc", "ProdType", "TDS", "SDS"

What happens when you try?

The Prod_results.php isn't filtering the results. See private message for URL.

Shouldn't there be a URL parameter of some sort? I've tried altering the recordset using a URL Param = Prod ID and Form Variable = Prod ID, but the results still aren't filtered.

Thanks

I can't view your localhost server... Are you starting with the search page and entering a search string and submitting? It should be adding a url parameter at that point.

Everything was configured within the wizard as four separate search fields. It doesn't work now that the search fields are condensed to one.

The only server behaviors I can see that Data Assist has created are on the results page: DataAssist Search (WADAProd) and recordset (WADAProd). There are no record sets on the Search page, that I can see, that reference the Search text field.

The server behavior DataAssist Search (WADAProd) is configured like this:
Separator: AND
Column: Lists the correct columns, but can't select any
Column type: Text
Comparison: includes
Filter
Type: keyword
value: <?php echo $row_WADAProd['ProdID']; ?>
Keyword AND: AND
Keyword OR: OR

Not sure what Start and End Encapsulator is, and checked/unchecked value is grayed out.

The WADA Prod recordset is configured like this:
Connection: ProductsDb
Table: Prod
Columns: All
Filter: None

I only included the localhost URL so you could see no URL parameter is being passed.

Tried editing using the Search Wizard only, which created a new Submit button, but returned no results.

Also tried going back to the tutorial 'http://www.webassist.com/tutorials/Create-a-search-page-that-displays-filtered-results' but couldn't get that to work either.

The search page doesn't need any code. It just needs to submit to the results page. If the form uses method="get" it should automatically add any form fields and their values to the URL. So I'm not sure how you are getting to the results page without the url parameter, but it would imply an issue with the search page form.

Do you have it on a live server where I could view the page for testing and see if I could spot the problem?

This post has been deleted.

Unable to move forward on this.

The index.php page has one search field. Though the URL has the correct parameter, it returns the whole Db.

The Prod_results.php page has three search fields (ProdNum, ProdName, ProdType). Though the URL has the correct parameter, only ProdNum returns the correct results. The other three return the whole Db.

I've edited source code and WA server behaviors multiple times, and even tried creating new pages (multiple crashes led me back to troubleshooting the existing pages).

The pages aren't loaded on a server.

Thanks