<cfinclude template="header.cfm">


<div id="content" style="margin-left:250px;">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:250px;">
	  <Cfsetting requestTimeout="5000">
<cfquery name="getstuff" datasource="#ds#">
select id,event,venue,astart,aend,city
from ActivityPlannerHold
where statusnum = 0
and year(aend) > 2022
<!---and cg = 'on'--->
order by id desc
</cfquery><Cfoutput>#getstuff.recordcount#</Cfoutput>
<strong>Not Approved:</strong><Br />
<Cfoutput query="Getstuff">

<Cfif #aend# eq aend[currentrow-1]
and astart eq astart[currentrow-1]
and event eq '#event[currentrow-1]#'
and venue eq '#venue[currentrow-1]#'

>
	dupe<br>
<Cfelse>nodupe
	<cfhttp url="https://www.cityguideny.com/newadmin/approvecalendar2a.cfm?eventid=#id#" method="get" resolveurl="yes" charset="iso-8859-1" path="/home/home2/cgny/public_html" file="amazonbooks.htm" timeout="10">
<a href="/newadmin/approvecalendar.cfm?eventid=#id#&blank=on##jump">#event#</a> (#venue# - #city#) -
#astart# - #aend# <a href="delplannerhold.cfm?id=#id#">delete</a> | <a href="approvecalendar2a.cfm?eventid=#id#">approve</a>

<Cfif aend eq ''>
	<Cfquery name="udpas" dataSource="#ds#">
		update ActivityPlannerHold
		set aend = '#astart#'
		where id = #id#
	</cfquery>

	</Cfif>
<p>
</cfif>
</Cfoutput>
<p>

</td></tr></table></body></html>