Because my memory RE: logical operator precedence is often fallible and my WHERE clauses are often complicated, I almost always use parens, even when unnecessary. Also, they make "SQL I wrote years ago and haven't looked at since" easier to understand quickly.
On Wed, Apr 10, 2013 at 3:13 PM, Bruce Sorge <[email protected]> wrote: > > I put parens around the name and birthdate and it works fine now. > > Thanks, > > Bruce > On Apr 10, 2013, at 4:01 PM, John M Bliss <[email protected]> wrote: > > > > > Agreed: next step: add parens to make it explicit. If *that* does not > work, > > let us know. > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
