Viewer code error - x AND y OR y

3 posts by 2 authors in: Forums > CMS Builder
Last Post: October 28, 2009   (RSS)

Re: [benedict] Viewer code error - x AND y OR y

By Dave - October 28, 2009

Hi benedict,

You can add brackets to more explicitly specify your conditions. Try this:

'where' => ' region LIKE "%Queensland%" AND (store_type LIKE "%ABC%" OR store_type LIKE "%Other%") ',

Let me know if that works for you.
Dave Edis - Senior Developer
interactivetools.com

Re: [Dave] Viewer code error - x AND y OR y

Works great - thanks.