Viewer code error - x AND y OR y
3 posts by 2 authors in: Forums > CMS Builder
Last Post: October 28, 2009 (RSS)
By benedict - October 28, 2009
Hi guys,
I have a bunch of stores on a page pulled from store locations table. I want to show only stores that are from region 'Queensland" AND are a store_type of either a "ABC" store or an "other" store.
My viewer code is this:
But it keeps showing stores from other states. I presume it is because for some reason it is only paying attention to the second part of the condition I have set. What's wrong with my syntax?
Thanks in advance!
I have a bunch of stores on a page pulled from store locations table. I want to show only stores that are from region 'Queensland" AND are a store_type of either a "ABC" store or an "other" store.
My viewer code is this:
list($store_locationsqldRecords, $store_locationsqldMetaData) = getRecords(array(
'tableName' => 'store_locations',
'loadUploads' => '0',
'where' => ' region LIKE "%Queensland%" AND store_type LIKE "%ABC%" OR store_type LIKE "%Other%" ',
));
But it keeps showing stores from other states. I presume it is because for some reason it is only paying attention to the second part of the condition I have set. What's wrong with my syntax?
Thanks in advance!
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.
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
interactivetools.com