Man... do I feel like a complete idiot.. I think I should no longer consider myself even a beginner CF programmer!
Jim, somewhere along the line I got the idea that the default values for Form.Earliest_Birthdate_Day was "Day"... it's not... it's "0"! The same is true for the other birthdate form values... all "0"... what a dummy! I don't even remember changing anything on the form page! AAAAAAAHHHHHHH! I don't feel better yet... it'll take a week to get over this one. But at least my world makes sense again... talk about self-inflicted pain! 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:261691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
