<cfif parameterexists(form.captchatext) and '#form.captchatext#' eq '#form.chide#'>
<Cfinclude template="header.cfm">

<CFSET CurrentDateTime = #CreateODBCDateTime(Now())#>


<cfparam name="form.ages" default="">
<CFQUERY NAME="Insert" datasource="#ds#">
  INSERT INTO ListingsRequests (
tablename,itemid,firstname,lastname,contactemail,requestdate,contactphone,contactquestion,entrydate,mag)
  VALUES ('#form.tablename#',#form.itemid#,'#Form.firstname#','#Form.lastname#','#Form.contactemail#','#Form.requestdate#','#form.contactphone#','#form.contactquestion#',#CurrentDateTime#,2)
</CFQUERY>

<Cfquery name="getinfo" datasource="#ds#">
select *
from CampListings
where name = '#form.placename#'
</cfquery>

<Cfset form.nympregion = '#getinfo.region#'>


	<Cfset emailto = '[email protected],[email protected]'>

<cfif #form.nympregion# contains 'Manhattan' or #form.nympregion# contains 'New York'><cfset emailto='#emailto#,[email protected],[email protected]'></cfif>
<cfif #form.nympregion# contains 'Brooklyn'><cfset
emailto='#emailto#,[email protected],[email protected],[email protected]'></cfif>
<cfif #form.nympregion# contains 'Queens'><cfset emailto='#emailto#,[email protected],[email protected]'></cfif>
<cfif #form.nympregion# contains 'Rockland'><cfset emailto='#emailto#,[email protected],[email protected]'></cfif>
<cfif #form.nympregion# contains 'Westchester'><cfset emailto='#emailto#,[email protected],[email protected],[email protected]'></cfif>
<cfif #form.nympregion# contains 'Fairfield'><cfset emailto='#emailto#,[email protected],[email protected]'></cfif>
<cfif #form.nympregion# contains 'Staten Island'><cfset emailto='#emailto#'></cfif>
<cfif #form.nympregion# contains 'Bronx'><cfset emailto='#emailto#,[email protected]'></cfif>
<cfif #form.nympregion# contains 'Essex'><cfset emailto='#emailto#'></cfif>
<cfif #form.nympregion# contains 'Nassau'><cfset emailto='#emailto#,[email protected],[email protected]'></cfif>
<cfif #form.nympregion# contains 'Bergen'><cfset emailto='#emailto#,[email protected],[email protected]'></cfif>
<cfif #form.nympregion# contains 'Suffolk'><cfset emailto='#emailto#,[email protected],[email protected]'></cfif>


<cfset tovar = '#emailto#,#getinfo.email#'>

<Cfif #getinfo.email# is not ''>
<cfset tovar = '#emailto#,#getinfo.email#'>
<Cfelse>
<cfset tovar = '#emailto#'>
</Cfif>



<cfif parameterexists(form.advertiser) and #form.advertiser# gt 0>


<CFMAIL TO="[email protected]"
		FROM="#form.contactemail#"
        SUBJECT="NYMP Camp Fair Info Request: #form.placename#- #getinfo.region#"
             SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@">

The following request was placed on #Now()#.

Name: #Form.firstname# #Form.lastname#
E-Mail: #Form.contactemail# 
<cfif #form.contactphone# is not ''>Phone: #Form.contactphone#</cfif>

Zip: #form.zipcode#

Ages: #form.ages#

<cfif #form.requestdate# is not ''>Dates of Interest: #Form.requestdate#</cfif>

Question: #form.contactquestion#


</CFMAIL>
<cfelse>

<Cfquery name="getinfo" datasource="#ds#">
select *
from CampListings
where name = '#form.placename#'
</cfquery>

<CFMAIL TO="[email protected]"
		FROM="#form.contactemail#"
        SUBJECT="NYMP Camp Fair Info Request: #form.placename# - #getinfo.region#"
             SERVER="Mail.davlermedia.com"
username="Davler\webmail"
password="Webhome22@" type="html">

THIS IS AN INQUIRY ABOUT YOUR BUSINESS #form.placename#
<br /><br />
It came from an interested parent and was sent through
NYMetroParents.com
<br /><br />


Name: #Form.firstname# #Form.lastname#<br />
E-Mail: #Form.contactemail# <br />
Zip: #form.zipcode#<br />


Ages: #form.ages#<br />

<cfif #form.contactphone# is not ''>Phone: #Form.contactphone#<br /></cfif>

<cfif #form.requestdate# is not ''>Dates of Interest: #Form.requestdate#<br /><br /></cfif>

Question: #form.contactquestion#
<br /><br />
Received on: #Now()#.

<br /><br />
A NEW LEAD FROM NYMETROPARENTS.COM
<br /><br />
This is a parent who expressed interest in your services.  Please respond to this parent within 24 hours while their interest level is highest. 
<br /><br />
</CFMAIL>

</cfif>

<Table bgcolor="white" width="900"><tr><Td>
<font face="Verdana, Geneva, sans-serif" size=+1>
<B><br /><br /><br />
<Center>
Thank you, your inquiry has been sent to the Camp<p>
<a href="javascript:history.back();">Back...</a> or wait 5 seconds to be redirected to the homepage. 

<meta http-equiv="refresh" content="5;url=index.cfm">

</Td></tr></Table>
<br /><br /><br />
<p>




</cfif>