<cfparam name="form.arrivedate" default="#dateformat(currentdatetime,'yyyy-mm-dd')#">
<cfif #form.arrivedate# eq ''>
<cfset form.arrivedate = #dateformat(currentdatetime,'yyyy-mm-dd')#>
</cfif>

<cfset newdeparturedate = #dateadd('d',380,CurrentDateTime)#>

<cfparam name="form.departuredate" default="#dateformat(newdeparturedate,'yyyy-mm-dd')#">
<cfif #form.departuredate# eq ''>
<cfset form.departuredate = #dateformat(currentdatetime,'yyyy-mm-dd')#>
</cfif>



<cfquery name="getevents" datasource="#ds#">
select
id,updatedby,dateend,datestart,activityname,name,description,hours,address,address2,state,city,zip,phone,website,pk,pkb,pkq,pkw,pkr,phonex,enhanceddescription,shortdescription
from ActivityPlanner
where 1=1
and (catid3 > 0 or catid4 > 0)
and status=0

<cfif parameterexists(form.cg)>
and cg = 'on'
</cfif>
<cfif parameterexists(form.ml)>
and ml = 'on'
</cfif>
<cfif parameterexists(form.pk)>
and  nympregion = 'manhattan'
</cfif>
<cfif parameterexists(form.pkq)>
and  nympregion = 'queens'
</cfif>
<cfif parameterexists(form.pkb)>
and  nympregion = 'brooklyn'
</cfif>
<cfif parameterexists(form.pkw)>
and  nympregion = 'westchester'
</cfif>
<cfif parameterexists(form.pkr)>
and  nympregion = 'rockland'
</cfif>


<cfif parameterexists(form.pkbronx)>
and  nympregion = 'bronx'
</cfif>
<cfif parameterexists(form.pkstaten)>
and  nympregion = 'Staten Island'
</cfif>
<cfif parameterexists(form.pkessex)>
and  nympregion = 'Essex'
</cfif>
<cfif parameterexists(form.pknassau)>
and  nympregion = 'Nassau'
</cfif>
<cfif parameterexists(form.pkfairfield)>
and  nympregion = 'Fairfield'
</cfif>
<cfif parameterexists(form.pkbergen)>
and  nympregion = 'Bergen'
</cfif>
<cfif parameterexists(form.pksuffolk)>
and  nympregion = 'Suffolk'
</cfif>

<cfif parameterexists(form.mainpage) and form.mainpage is not 'all'>
and mainpage = #form.mainpage#
</cfif>


  <cfif parameterexists (form.hasphoto) and form.hasphoto eq 'Yes'>
	and photo <> ''
</cfif>
  <cfif parameterexists (form.hasphoto) and form.hasphoto eq 'No'>
	and photo = ''
</cfif>


<cfif parameterexists(form.catid3) and form.catid3 is not 0>
and (catid3 = #form.catid3# or catid4 = #form.catid3#)
</cfif>


<cfif parameterexists (form.searchterm) and #form.searchterm# is not ''>
and (name like '%#form.searchterm#%' or enhanceddescription like '%#form.searchterm#%' or activityname like '%#form.searchterm#%')
</cfif>


<cfif parameterexists (form.newsletterpickup) and form.newsletterpickup is not 'All'>
	and newsletterpickup = '#form.newsletterpickup#'
</cfif>
<cfif parameterexists (form.ArriveDate)>
and
(
(datestart between '#dateformat(form.arrivedate,'yyyy-mm-dd')#' and '#dateformat(form.departuredate,'yyyy-mm-dd')#')
or
(dateend  between '#dateformat(form.arrivedate,'yyyy-mm-dd')#' and '#dateformat(form.departuredate,'yyyy-mm-dd')#')
or
datestart = '#dateformat(form.arrivedate,'yyyy-mm-dd')#'
or
dateend = '#dateformat(form.arrivedate,'yyyy-mm-dd')#'
or
(datestart < '#dateformat(form.arrivedate,'yyyy-mm-dd')#' and dateend > '#dateformat(form.departuredate,'yyyy-mm-dd')#')
<cfif #form.arrivedate# eq  #form.departuredate#>
or

(datestart <= '#dateformat(form.arrivedate,'yyyy-mm-dd')#' and dateend >= '#dateformat(form.arrivedate,'yyyy-mm-dd')#')

</cfif>
)

</cfif>
order by datestart
</cfquery>

<table border="1" cellpadding="4" cellspacing="0">
	<Tr><Td><b>EVENT</b></Td>
<td><b>ONLINE</td>
<td><b>PRINT</td>
	<td><b>DIFF?</td>
</tr>
<Cfoutput query="getevents">
<Tr><Td><a href="/editcalendar.cfm?id=#id#">#activityname# @ #name#</a></Td>

<Td>

	<Cfif #enhanceddescription# eq ''>
	    <Cfset onlinedesc = '#description#'>
<cfelse>
	    <Cfset onlinedesc = '#enhanceddescription#'>

</Cfif>

<cfset wordstr = trim(onlinedesc)> <cfset wordstr = replaceList(wordstr, "'.""?","")> <cfset words = reMatch("[[:word:]]+", wordstr)>
#arraylen(words)#
<cfset a = #arraylen(words)#>


</Td>

	<Td>
		<cfset wordstr = trim(shortdescription)> <cfset wordstr = replaceList(wordstr, "'.""?","")> <cfset words = reMatch("[[:word:]]+", wordstr)>
#arraylen(words)#
<cfset b = #arraylen(words)#>

	</Td>

<td  >
	<cfif #a# is not #b#>DIFFERENT</cfif>
</td>
</Cfoutput>
</table>