Re: [Jason] Adding criteria to a 'where' clause
Jason,
Thanks for catching that.
Yes they are identical, and I get a completely different (and correct) result with one removed.
Seems that the OR tells the logic to test for condition A, and then test for statement A AND B combined, and if either OR is true, list the records.
As if there were parentheses around the 2 "anded" conditions.
Anyway, the short answer is that it works now. (I still needed to change the double quotes to single quotes)
Jerry
The first CMS Builder reference book is now available on-line!
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php