Search box returns "0" results when I use the word "and"

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
ghansard
Ensign (ENS)
Ensign (ENS)
Posts: 19
Joined: Tue Jul 02, 2013 12:52 pm

Search box returns "0" results when I use the word "and"

Post by ghansard » Mon Jan 20, 2014 12:38 pm

For example.

I can type in "Lee and Grant" and get "0" results, but if I type "lee" and "grant" separetely it works.

User avatar
ForumsAdmin
AbleCommerce Moderator
AbleCommerce Moderator
Posts: 399
Joined: Wed Mar 13, 2013 7:19 am

Re: Search box returns "0" results when I use the word "and"

Post by ForumsAdmin » Wed Jan 22, 2014 4:53 am

In FTS words like these are considered noise words and they are ignored.

ghansard
Ensign (ENS)
Ensign (ENS)
Posts: 19
Joined: Tue Jul 02, 2013 12:52 pm

Re: Search box returns "0" results when I use the word "and"

Post by ghansard » Tue Feb 18, 2014 9:45 am

Is this common with able commerce software or is there anything that I can do to allow the search term "and"

User avatar
ForumsAdmin
AbleCommerce Moderator
AbleCommerce Moderator
Posts: 399
Joined: Wed Mar 13, 2013 7:19 am

Re: Search box returns "0" results when I use the word "and"

Post by ForumsAdmin » Thu Feb 27, 2014 5:03 am

If you don't use Full Text Search (FTS) then search terms like and will also be taken into consideration.

Post Reply