close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Adding one search field to existing DataAssist results page

Thread began 1/19/2021 12:08 pm by tmcbinc99963 | Last modified 1/19/2021 3:01 pm by Ray Borduin | 77 views | 8 replies |

tmcbinc99963

Adding one search field to existing DataAssist results page

I would like to add a single search field to an existing DA results page that was set up with WA plugins.

I added the search, but can't seem to get them both to show results. Can they both use the same DA created recordset and Search server behaviors?

The search field created with DA works fine, but the single search I added has never worked and shows all results. Have tried multiple iterations of text field names, wizard settings, etc. with no change.

The site isn't live yet, so hopefully you'll be able to see the problem by viewing the page. If not, I can throw it up on our server.

Sign in to reply to this post

Ray BorduinWebAssist

Your text field name is the same as your button name. The name of your form elements need to be unique for each form.

What column are you trying to search against with this field? I don't see the text field name in the search server behavior either.

Sign in to reply to this post
Did this help? Tips are appreciated...

tmcbinc99963

I'm looking to search the whole database with a single text field search.

Sign in to reply to this post

Ray BorduinWebAssist

All columns? You would need to update your database search server behavior and add a keyword search and select all of the columns.

Sign in to reply to this post
Did this help? Tips are appreciated...

tmcbinc99963

I changed the name of one of the forms, and included a keyword search for all columns. Same problem.

Should a value be set for the keyword in the wizard? If so, should the value be taken from the form, session, or form name?

The URL for each search is included in the PM. Are these supposed to be different?

Attached Files
Paintings_results.php.zip
Sign in to reply to this post

Ray BorduinWebAssist

Please attach the updated page.

Sign in to reply to this post
Did this help? Tips are appreciated...

Ray BorduinWebAssist

You still didn't update your form element name. You have:

html:
<input type="text" name="Search" class="form-control mr-sm-2" placeholder="Search" aria-label="Search">
<span class="buttonFieldGroup" >
<input type="submit" value="Search" class="formButton unstyled" id="Search" name="Search" />
</span>


it should be:

html:
<input type="text" name="Keyword" class="form-control mr-sm-2" placeholder="Search" aria-label="Search">
<span class="buttonFieldGroup" >
<input type="submit" value="Search" class="formButton unstyled" id="Search" name="Search" />
</span>



You also didn't bind the keyword search in your Database Search server behavior to a form value.

Update the keyword search and click the lightning bolt to select the newly renamed "Keyword" field to search against.

Sign in to reply to this post
Did this help? Tips are appreciated...

tmcbinc99963

Updated page.

Sign in to reply to this post

Ray BorduinWebAssist

I don't see any of the updates I suggested in the latest zip.

The form element is still named search and the keyword search in the database search server behavior still doesn't have a value set.

Sign in to reply to this post
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.

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...