close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Data Assist Search using a keywords field

Thread began 3/14/2014 2:45 pm by sandy170299 | Last modified 3/14/2014 4:36 pm by sandy170299 | 225 views | 4 replies |

sandy170299

Data Assist Search using a keywords field

I have a field that is called keywords. However, if I enter more than one keyword, it returns no results, even though both words do exist in the text area field. This is how it is currently set up.

column: keywords
column type: text
comparison: includes
filter type: value
value:<?php echo ((isset($_POST["keywords"]))?$_POST["keywords"]:""); ?>

Should the keywords be comma separated? Thanks. I've tried changing it to type=keyword, but that would only return one value as well.

Sign in to reply to this post

Jason ByrnesWebAssist

you should leave the type as keyword

the keyword criteria has settings for the Or Separator, the And separator and the start / end encapsulator.

these settings effect how you should enter the search terms.

the default settings are:

Keyword AND separator: ", " <- comma followed by a space
Keyword OR seperator: " " <- a space

Start Encapsulator: " <- double quote
End Encapsulator: " <- double quote

this would mean searching for:
foo bar

would look for foo OR bar in the record

foo, bar

would look for foo OR bar in the record

"foo bar"

would look for the string "foo bar" in the record

Sign in to reply to this post

sandy170299

Still having trouble with this. Performed a search for state = MN, and keywords = Otter, green. No results returned, even though otter and green are both in the keywords field. See PM for URL.

I have a better example. Same search page, no state, but keywords = blue, green.

Sign in to reply to this post

Jason ByrnesWebAssist

send a copy of the results page pleases.

Sign in to reply to this post

sandy170299

I think it just worked.... Thank you!

Sign in to reply to this post

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