Hi, Bobby, and thanks for the reply... I knew it was a long shot, but I tried it and got a query error.
Actually, "Day" & "Month" are not variables, but are the default values for selects. So, if the user doesn't specify another value for day or month, such as "1" for Day and "Jan" for Month, then the query is supposed to bypass another in the containing CFIF statement. The strangest thing is that it worked fine yesterday, but today won't work unless that code is taken out of the query or the 4 formfields involved in the CFIF wrapper have values specified other than the defaults. Under all other circumstances the query runs fine... So odd... Rick -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Saturday, November 25, 2006 1:38 PM To: CF-Talk Subject: RE: How do I get number of birthdays? It looks to me like Day is a variable but you are comparing the value of #Form.Earliest_Birthdate_Day# to the actual WORD "Day" instead of the value of a variable named Day. Try this instead <CFIF Form.Earliest_Birthdate_Day is not Day and Form.Earliest_Birthdate_Month is not Month and Form.Latest_Birthdate_Day is not Day and Form.Latest_Birthdate_Month is not Month> ...:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
