Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Adding 'OR' to recordset breaks results page

Adding 'OR' to recordset breaks results page

Thread began 8/31/2017 7:22 pm by Brendan | Last modified 8/31/2017 10:00 pm by Ray Borduin | 328 views | 1 replies |

8/31/2017 7:22 pm | #1 Brendan

Adding 'OR' to recordset breaks results page

I have a field called 'DetailSchool' which is what I am searching for via URL (?DetailScool=XYZ&Search=Search) where the recordset includes "WHERE DetailProductID = '2'. This works great.

But when I add "WHERE DetailProductID = '2' OR '3', the results no longer filter by the DetailSchool info in the URL. I have also tried "WHERE DetailProductID <> '99' but that seems to break the search too.

Am I formatting something wrong, or is this just not going to work? Any other ideas on how i might do this. The reason the school name isn't in the recordset is because i'm trying to send 45 schools to the same results page, and just filter the result based on the URL.

8/31/2017 10:00 pm | #2 Ray BorduinWebAssist

That isn't valid SQL you would have to either use:
WHERE DetailProductID = '2' OR DetailProductID = '3'
or
WHERE DetailProductID IN ('2','3')

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.