Groups > comp.databases.ms-access > #864

Re: dynamic criteria being ignored by query

From	"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com>
Newsgroups	comp.databases.ms-access
Subject	Re: dynamic criteria being ignored by query
Date	2011-04-07 17:29 -0400
Organization	A noiseless patient Spider
Message-ID	<inlab8$jk6$1@dont-email.me> (permalink)
References	<5c35353f-1827-4170-bc4e-57826cf3522c@d28g2000yqf.googlegroups.com> <Xns9EBF871C0F996f99a49ed1d0c49c5bbb2@74.209.136.92>

Show all headers | View raw

According to the Help file, the precedence of boolean operators is Not, And, 
Or, Xor, Eqv, Imp

Doesn't that mean that

WHERE condition1 OR condition2 AND condition 3

will always be evaluated at

WHERE condition1 OR (condition2 AND condition 3)

?

"David-W-Fenton"  wrote in message 
news:Xns9EBF871C0F996f99a49ed1d0c49c5bbb2@74.209.136.92...

Are there any OR's in the WHERE clause? If so, you might need to use
parentheses to get the right result. For instance:

  WHERE condition1 OR condition2 AND condition 3

...will be unpredictable as to what it will retrieve. It could
alternatively be interpreted in either of these two ways:

  WHERE (condition1 OR condition2) AND condition 3
  WHERE condition1 OR (condition2 AND condition 3)

The parentheses are essential to insure that it gets interpreted in
the way you want it to be interpreted.

-- 
David W. Fenton                  http://www.dfenton.com/
contact via website only     http://www.dfenton.com/DFA/

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

dynamic criteria being ignored by query Tony_E <bluestealth94@hotmail.com> - 2011-04-05 05:16 -0700
  Re: dynamic criteria being ignored by query "zuckermanf@gmail.com" <zuckermanf@gmail.com> - 2011-04-05 07:52 -0700
    Re: dynamic criteria being ignored by query Tony_E <bluestealth94@hotmail.com> - 2011-04-05 07:57 -0700
      Re: dynamic criteria being ignored by query John Spencer <JSPENCER@Hilltop.umbc> - 2011-04-05 11:36 -0400
        Re: dynamic criteria being ignored by query Tony_E <bluestealth94@hotmail.com> - 2011-04-05 08:46 -0700
  Re: dynamic criteria being ignored by query "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-06 17:16 +0000
    Re: dynamic criteria being ignored by query "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> - 2011-04-07 17:29 -0400
      Re: dynamic criteria being ignored by query "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-09 21:22 +0000
        Re: dynamic criteria being ignored by query "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> - 2011-04-10 09:12 -0400

csiph-web