Well I could have Sworn it worked when I tested it. However I must've missed something.
Sent from my iPhone 4S. On Apr 10, 2013, at 4:17 PM, John M Bliss <bliss.j...@gmail.com> wrote: > > 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 <sor...@gmail.com> 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 <bliss.j...@gmail.com> 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:355350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm