close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How to revise Data Assist Search page form items

Thread began 2/19/2016 11:22 am by tmcbinc99963 | Last modified 3/17/2016 3:27 pm by Ray Borduin | 844 views | 34 replies |

tmcbinc99963

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

tmcbinc99963

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

Sign in to reply to this post

Ray BorduinWebAssist

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?

Sign in to reply to this post

tmcbinc99963

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

tmcbinc99963

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.

Sign in to reply to this post

Ray BorduinWebAssist

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?

Sign in to reply to this post

tmcbinc99963

This post has been deleted.

tmcbinc99963

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

Sign in to reply to this post
loading

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...