CF/Access Date - Birthday query

Hi Everyone,

I tried searching but didn't find what I was looking for. Aniway, I'm trying to query from an Access DB to see who has a birthday today and here's what I did, but it doesnt seem to work right, I think the code for extracting month and days isn't correct, could somebody please fix it for me? thanks


<cfset currentmonth = Month(Now())>
<cfset currentday = day(Now())>
<cfquery name="getbirthdays" datasource="employees">
select * from tblEmployees where birthday is not null
</cfquery>
</cfoutput>

<cfoutput query="getbirthdays">
<cfif #MonthAsString(Month(birthday))# eq #currentmonth#>
#firstname# #lastname#
</cfif>
none
</cfoutput>

Showing the code doesn't help if you don't explain what the problem or error is.

Hi Kiteless

the error is, the condition where birthday.month = currentmonth does not get applied, it's just like empty codes

it works now hehehe

why not just do it this way:

<cfquery name="birthdays" datasource="employees">
SELECT birthday, firstname, lastname
FROM tblEmployees
WHERE birthday = #dateFormat(now())#
</cfquery>

<cfoutput query="birthdays">
#firstname# #lastname#
</cfoutput>

i think that way is much simpler then what youre using, unless you have additional code that needs it to be that way.

Hi,

correct me if i'm wrong but if you use

WHERE birthday = #dateFormat(now())#

wouldn't that return only the users whose birthday is today? meaning they'd be born today?

well isnt that what you are trieing to do??

no CFSETs, no local variables, no fuss, no muss, and most importantly, you don't return the entire employee table just to CFIF them in in the CFOUTPUT loop to find out who has a birthday, you just return only those employees who do --

naw, you misread my code, I checked month then day

wow, that is so much shorter and less confusing, thanks for the tip