Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › DataAssist Search Issue searching with "And"

DataAssist Search Issue searching with "And"

Thread began 12/16/2020 9:59 am by keith505 | Last modified 12/16/2020 2:41 pm by Ray Borduin | 41 views | 2 replies |

12/16/2020 9:59 am | #1 keith505

DataAssist Search Issue searching with "And"

I have a column that contains for example:

Viola
Violin and Piano
Orchestra
Viola with Orchestra

When I do a search on the above field that includes the word "and" I get no results when there are many results. The generated SQL looks correct: "Search AND (Instruments = 'Viola and Piano')" however, it appears to me the "AND" is causing trouble somewhere. It is only the fields with AND that have this issue. Any thoughts about this?

12/16/2020 10:01 am | #2 keith505

I have attached FTP info in private message if it would be helpful.

12/16/2020 2:41 pm | #3 Ray BorduinWebAssist

I've updated your search and results page to address this issue. You can use comma separated values in the search field to search for multiple instruments.

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.