> The way you had it before you could have possibly had all (or any) of the parameters evaluate to false,
Jim, the odd thing is that the CFIF statement should prevent any of the birthdate code from being processed at all if no days or months are selected. That's the oddest part. And I can't find any missing characters which would explain the problem. Usually, this sort of problem comes down to a typo, but I can't see it. Rick -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Saturday, November 25, 2006 9:57 PM To: CF-Talk Subject: Re: How do I get number of birthdays? Rick, See above...I added in parentheses to group the birthdate stuff, so that it is evaluated together. The way you had it before you could have possibly had all (or any) of the parameters evaluate to false, but if the earliest month was greater than the latest month, that OR would have made it so records would be returned if that last part about the latest birthdate was true. Hopefully that makes sense...it's kind of hard to explain without pointing at it. Anyway, that is the only thing I can think of that would cause what you are describing. -jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
