<cfif not parameterexists(seoer) and not parameterexists(url.meet) and not parameterexists(url.history) and not parameterexists(url.brochure) and not parameterexists(url.contactus) and not parameterexists(url.multimedia)>

<cfif not parameterexists(url.id) or not isnumeric(url.id)>
<cfabort></cfif>

<Cfquery name="getseo" datasource="#ds#" cachedwithin="#createtimespan(0,6,3,0)#">
select seo_friendly
from CampListings
where id = #url.id#
</Cfquery>

<cflocation url="/listing/#getseo.seo_friendly#" addtoken="no">
</cfif>



<cfparam name="campregion" default="Westchester">
<cfparam name="camplogo" default="campfairnewlogo.jpg">



  <cfif #cgi.http_host# eq 'www.longislandcampfair.com' or #cgi.http_host# eq 'longislandcampfair.com'>
<Cfset campregion = 'Long Island'>
<Cfset camplogo = 'LI-OnlineCampFairLogo2.png'>


</cfif>

<cfif not parameterexists(url.id) or not isnumeric(url.id)>
<cfabort></cfif>

<Cfquery name="getlistings" datasource="#ds#">
select * from CampListings
where id = #url.id#
</Cfquery>


<cfset pagetitle = 'Main'>

<Cfif parameterexists(url.meet)>
<cfset pagetitle = 'Meet the Directors'>
</Cfif>
<Cfif parameterexists(url.history)>
<cfset pagetitle = 'History/Description'>
</Cfif>
<Cfif parameterexists(url.brochure)>
<cfset pagetitle = 'Camp Brochure'>
</Cfif>
<Cfif parameterexists(url.multimedia)>
<cfset pagetitle = 'Multimedia'>
</Cfif>
<Cfif parameterexists(url.contactus)>
<cfset pagetitle = 'Contact'>
</Cfif>

<!---
<cfquery name=addphoto datasource="cityguide">
INSERT INTO ListingStats (idnumber,ipnumber,pagetitle,datetime,tablename)
VALUES	(#url.id#,'#cgi.remote_addr#','#pagetitle#','#dateformat(currentdatetime,'yyyy-mm-dd')#','CampListings')
</cfquery>
---->



<cfsavecontent variable="headercontent">
<cfoutput>
<title>#getlistings.name# (#campregion# Camp Fair)</title>
<meta name="keywords" content="#getlistings.name#, Camp Fair, New York, #getlistings.name# New York, #getlistings.name# #campregion#">
<meta name="description" content='#replacenocase(getlistings.fulldescription,"'","")#'>
</cfoutput>
</cfsavecontent>



<Cfinclude template="header.cfm">

<table width="900" cellpadding="4" cellspacing="0" border="3" bordercolor="f9a755" bgcolor="#FFFFFF">
<Tr><td valign="top" width="100%">

<Table width="100%"><tr bgcolor="f7a55c"><td>

<Table><Tr><td>

<Cfoutput query="getlistings">
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 

<strong>#name#<br />
</strong><font color="010101" face="Arial, Helvetica, sans-serif" style="font-size:12pt"> 

#address# #city# #state# #zip#<Br>
#phone#<br>

<cfif #offaddress# is not ''><br />
<strong>Off-Season: </strong>#offaddress# #offcity# #offstate# #offzip#<Br>
#phone#<br>

</cfif>
<Cfif #left(website,5)# eq 'http:'>

<a href="linktrack.cfm?id=#url.id#" target="_new">#website#</a>

<cfelse>
<a href="linktrack.cfm?id=#url.id#" target="_new">#website#</a>

</Cfif>
<p>


</Cfoutput></td></Tr></Table>


</td>
<Td valign="middle">
<!-- AddThis Button BEGIN -->
<div class="addthis_toolbox addthis_default_style ">
<a class="addthis_button_facebook_like" fb:like:layout="button_count"></a>
<a class="addthis_button_tweet"></a>
<a class="addthis_button_google_plusone" g:plusone:size="medium"></a>
<a class="addthis_counter addthis_pill_style"></a>
</div>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#pubid=dlmiller1"></script>
<!-- AddThis Button END -->

<Table><Tr><Td></td></tr></table>
<Cfoutput>
<a href="/camplisting.cfm?id=#url.id#&contactus=on"><img src="/sendmoreinfotop.png" border="0" width="500"></a>
</cfoutput>

</Td>
</Tr></table>



</tr>
<cfif not parameterexists(url.contact)> 
<tr bgcolor="#21415a"><Td>
<Table width="100%"><Tr>
<Td><a href="/camplisting.cfm?id=<cfoutput>#url.id#</cfoutput>" style="text-decoration:none"><font color="ffffff" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
Home</font></a> </Td>

<Td><a href="/camplisting.cfm?id=<cfoutput>#url.id#</cfoutput>&meet=on" style="text-decoration:none"><font color="ffffff" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
Meet the Directors</font></a> </Td>
<Td><a href="/camplisting.cfm?id=<cfoutput>#url.id#</cfoutput>&history=on" style="text-decoration:none"><font color="ffffff" face="Arial, Helvetica, sans-serif" style="font-size:16pt">History/Description</font></a> </Td>
<Td><a href="/camplisting.cfm?id=<cfoutput>#url.id#</cfoutput>&brochure=on" style="text-decoration:none"><font color="ffffff" face="Arial, Helvetica, sans-serif" style="font-size:16pt">Camp Brochure</font></a> </Td>
<Td><a href="/camplisting.cfm?id=<cfoutput>#url.id#</cfoutput>&multimedia=on" style="text-decoration:none"><font color="ffffff" face="Arial, Helvetica, sans-serif" style="font-size:16pt">Photos & Video</font></a> </Td>
<Td><a href="/camplisting.cfm?id=<cfoutput>#url.id#</cfoutput>&contactus=on" style="text-decoration:none"><font color="ffffff" face="Arial, Helvetica, sans-serif" style="font-size:16pt">Contact</font></a></Td>
</tr>
</Table>
</Td>
</tr>
</cfif>
<tr><Td>


<cfif parameterexists(url.meet)>
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
<b><center>
Meet the Directors
</center></b>
<p>

<Cfquery name="Getspfd" datasource="#ds#">
select photo,description from ListingsPhotos
where itemid = #url.id# and tablename = 'CampListings'
and description = 'Meet the Director'
</Cfquery>


<cfoutput query="Getspfd">
<img src="http://cityguideny.com/listingsphotos/#photo#" width="200">
<p>


</cfoutput>

<cfoutput query="getlistings">#campdirector#</cfoutput>
<cfelseif parameterexists(url.history)>
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
<b><center>
Camp History and Description
</center></b>
<p>

<cfoutput query="getlistings">#camphistory#</cfoutput>
<cfelseif parameterexists(url.brochure)>

<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
<b><center>
Camp Brochure
</center></b>
<p>

<Cfquery name="Getspfd" datasource="#ds#">
select photo from ListingsPhotos
where itemid = #url.id#
and description = 'BrochurePDF'
</Cfquery>

<cfoutput query="Getspfd">
<iframe width="100%" height="600" src="http://www.cityguideny.com/listingsphotos/#photo#">
</iframe>
</cfoutput>

<cfelseif parameterexists(url.multimedia)>
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
<b><center>
Photos and Videos
</center></b>
<p>

<Cfquery name="Getspfd" datasource="#ds#">
select description from ListingsVideos
where itemid = #url.id#
</Cfquery>

<center> 

<cfoutput query="Getspfd">
#description#
</cfoutput>
</center>

<Cfquery name="Getspfd" datasource="#ds#">
select photo,description from ListingsPhotos
where itemid = #url.id# and tablename = 'CampListings'
and description <> 'BrochurePDF' and description <> 'Meet the Director' and photo <> ''
</Cfquery>

<center>
<cfoutput query="Getspfd">
<img src="http://cityguideny.com/listingsphotos/#photo#" width="600" /><br />
<font size="-1">
#description#
<p>


</cfoutput>
</center>



<cfelseif parameterexists(url.contactus)>
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
<b><center>
Contact Us
</center></b>
<p>

<Cfoutput query="getlistings">
<strong>#name#<br />
</strong>
#address# #city# #state# #zip#<Br>
#phone#<br>
<a href="linktrack.cfm?id=#url.id#" target="_new">#website#</a>

<cfif #offaddress# is not ''><br /><br>
<strong>Off-Season<br> </strong>#offaddress#<br> #offcity# #offstate# #offzip#<Br>
#phone#<br>

</cfif>

 </Cfoutput>



<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
<b><center>
Get More Information
</center></b>
<p>


<table width=100% border=1 cellspacing=0 cellpadding=4>
<tr bgcolor="#fbf6e3"><td align="left" >

<cfform name=log action="listingsinfosend.cfm?new=on" method="post" enctype="multipart/form-data">
<font face=verdana size=-1>

<Cfif #getlistings.email# is not ''>
<Cfoutput>
<input name="toemail" type="hidden" value="#getlistings.email#"></cfoutput>
<Cfelse>
<input name="toemail" type="hidden" value="">
</cfif>


<cfoutput>
<input name="tablename" type="hidden" value="Camps">
<input name="itemid" type="hidden" value="#url.id#">
<input name="placename" type="hidden" value="#getlistings.name#">
</cfoutput>
<table width=100%><tr>
<td align="left" ><font face=verdana size=-1 color="063255">
<b>First Name:</b></td><td align="left" ><cfinput TYPE="text" SIZE="25" NAME="FirstName" required="yes" message="Please enter your first name."></Td></tr>
<tr><td align="left" >

<font face=verdana size=-1 color="063255">
<b>Last Name:</b> </td><td align="left" ><cfinput TYPE="text" SIZE="25" NAME="LastName" required="yes" message="Please enter your last name."></Td></tr>

<tr><td align="left" ><font face=verdana size=-1 color="063255">
<strong>E-Mail:</strong>
</td><td align="left" >
 <cfinput type="text"
    name="contactemail"
    required="YES"
    onvalidate="testbox"
    message="Sorry, your entry is not a valid email address."
    size="25"
    maxlength="60">
	</Td></tr>
	<tr><td align="left" >
<font face=verdana size=-1 color="063255">
<b>Phone #:</b></td><td align="left" > <cfinput TYPE="text" SIZE="25" NAME="contactphone" required="no">
</td></tr>
	<tr><td align="left" >
<font face=verdana size=-1 color="063255">
<b>Zip Code:</b></td><td align="left" > <cfinput TYPE="text" SIZE="25" NAME="zipcode" required="yes" message="You must enter your zip code.">
</td></tr>
	<tr><td align="left" >
<font face=verdana size=-1 color="063255">
<b>Ages:</b></td><td align="left" > <cfinput TYPE="text" SIZE="25" NAME="Ages" required="no">
</td></tr>


<tr><td align="left" >
<font face=verdana size=-1 color="063255">
<b>I want to know about:</b></td><td align="left" > <textarea name="contactquestion" rows="7" cols="43" WRAP="VIRTUAL"></textarea> 
</td></tr>
     
     
 <tr align="left" valign="top">
      <td><b><font face=verdana size=-1 color="063255">Enter the code number shown below:</td>
      <td>
	  	    <p>
         <input name="captchaText" type="text" size="25" maxlength="100">
          <br>
		  <!--- show some helpful text so the user knows what this is --->
          <span style="font-size: x-small;">This helps prevent spam submissions. </span></p>
        <p>
			<!--- 
				Although you can display the image files directly it is not suggested
				as it will make it harder to clean up old files.
				
				Alagad suggests using a .cfm file to send the image to the user.  In 
				this example a file named captchaImage.cfm is created.  It accepts a 
				URL variable "image" which is name of the created file without the JPG
				extension. 
				
				The extension  is removed as a security measure.  It is added back on in 
				the captchaImage.cfm file to prevent users from passing in arbitrary paths
				to files.
			--->
		<Cfset x = randrange(1,10000)>
			<cfoutput>


<strong>		<font size=+1 face=verdana color="063255">	#x#</font></strong>
			<input name="chide" value="#x#" type="hidden" />
			</cfoutput>
            
            
	 
	 
<div align="right"><input type="submit" Value="SEND REQUEST...">&nbsp;&nbsp;</div>

</cfform>
</td></tr></table>


			
			
		</p></td>
    </tr>
</table>

<cfelse>

 


<Table width="100%"><Tr>
<td width="300" valign="top">

<Cfquery name="Getspfd" datasource="#ds#">
select photo,description from ListingsPhotos
where itemid = #url.id# and tablename = 'CampListings'
and description <> 'BrochurePDF' and description <> 'Meet the Director'
</Cfquery>


<cfoutput query="Getspfd">
<Cfif #photo# is not '' and #photo# is not 'nd'>
<img src="http://cityguideny.com/listingsphotos/#photo#" width="250">
<p>
</cfif>

</cfoutput>


</td>
<Td valign="top">



<table border="1" cellspacing="0" cellpadding="5" width="500">
<Tr><td valign="top"> 



<cfif #getlistings.campages# eq '' and #getlistings.campprice# eq '' and #getlistings.campspecialities# eq ''>

<img src="/campdirector_ComingSoon.png" />
<cfelse>

<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:16pt"> 
<strong>Camp Profile</strong></font>
<br /><Br />
<center>

<p>
<Table width="100%"><tr><Td valign="top">

<Cfoutput query="Getlistings">

<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Age</b><br />
<cfset zzz = rereplace(campages,',','<br>','ALL')>
<cfset zzz = rereplace(zzz,'2to4','2 to 4','ALL')>
<cfset zzz = rereplace(zzz,'5to8','5 to 8','ALL')>
<cfset zzz = rereplace(zzz,'9to13','9 to 13','ALL')>
<cfset zzz = rereplace(zzz,'13plus','13 plus','ALL')>

#zzz#<br />
<br />

<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Price Range</b><br />



<cfset zzz = rereplace(campprice,',','<br>','ALL')>
<cfset zzz = rereplace(zzz,'400','$700+','ALL')>
<cfset zzz = rereplace(zzz,'300','$400-$699','ALL')>
<cfset zzz = rereplace(zzz,'200','$200-$399','ALL')>
<cfset zzz = rereplace(zzz,'100','$100-$199','ALL')>

#zzz#<br />

<br />

<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Sessions</b><br />
<cfset zzz = rereplace(campsessions,',','<br>','ALL')>

#zzz#<br />
<br />

<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Gender</b><br />
#campgender#<br />

<Cfif #campspecialneeds# is not ''>
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Special Needs Welcome</b><br />
#campspecialneeds#<br />
</cfif>

</font>
</td><Td valign="top">
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Specialties</b><br />

<cfset zzz = rereplace(campspecialities,',','<br>','ALL')>
#zzz#


</td></Tr></table>

</cfoutput>
</cfif>

</Td></tr>
</table>

<Cfoutput query="Getlistings">
<Cfif #getlistings.advertiser# gt 0> 


<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Camp Highlights</b><br />
<font size=-1>
#paragraphformat(fulldescription)#
<p>

<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Transportation</b><br />
<font size=-1>

#paragraphformat(camptransportation)#
<p>
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Accreditation</b><br />
<font size=-1>

#paragraphformat(campaccredit)#
<p>

<a href="/camplisting.cfm?id=#url.id#&contactus=on"><img src="/sendmemoreinfobig.jpg" border="0" width="500"></a>

<br /><Br />

<cfelse>

<Cfif #description# is not ''>
<font color="063255" face="Arial, Helvetica, sans-serif" style="font-size:12pt"><b>Description</b><br />
<font size=-1>

#paragraphformat(description)#
<p>
<a href="/camplisting.cfm?id=#url.id#&contactus=on"><img src="/sendmemoreinfobig.jpg" border="0" width="500"></a>

<br /><Br />


</cfif>

</cfif>



</cfoutput>

</Td></Tr></Table>

</Cfif>



<Cfoutput>


<cfif not parameterexists(url.meet) and not parameterexists(url.history) and not parameterexists(url.brochure) and not parameterexists(url.contactus) and not parameterexists(url.multimedia)>
<center>
<a href="http://www.nymetroparents.com/camplogin.cfm?id=#url.id#"><img src="/campdirector-update.png" border="0" width="300"></a>
</center>
</cfif>
</Cfoutput>


</center>

</Body>

</html>