All pastes #624769 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-07-18 14:40 UTC
rendered paste body
<cfparam name="URL.month" default="#Month(Now())#">
<cfparam name="URL.year" default="#year(Now())#">
<cfparam name="FORM.user_id" default="#GetAuthUser()#">
<cfset dteNextMonth=URL.month+1>
<cfset dtePreviousMonth=URL.month-1>
<cfif dteNextMonth GT 12>
  <cfset dteNextMonth=1>
</cfif>
<cfif dtePreviousMonth LT 1>
  <cfset dtePreviousMonth=12>
</cfif>
<cfset dteCurrentMonth=#DateFormat(CreateDate(URL.year,URL.month,1),"MM/DD")#>
<cfset dteDaysInMonth=DaysInMonth(dteCurrentMonth)>
<cfset dteDayOfMonth=1>
<cfset dteFirstDayOfMonth=DayOfWeek(CreateDate(URL.year,URL.month,1))>
<cfset nCounter=1>
<cfset dteEndOfMonth=#DateFormat(CreateDate(URL.year, URL.month, dteDaysInMonth),"MM/DD")#>
<cfquery datasource="#sDSN#" name="qEvents">
SELECT *
FROM ach_client
WHERE (dob_1 BETWEEN '#dteCurrentMonth#%' AND '#dteEndOfMonth#') OR (dob_2 BETWEEN '#dteCurrentMonth#' AND '#dteEndOfMonth#')
</cfquery>
<cfdump var="#qEvents#">