| Server IP : 172.67.201.108 / Your IP : 216.73.216.68 Web Server : Apache/2.4.68 (Amazon Linux) OpenSSL/3.5.5 System : Linux ip-172-31-69-123.ec2.internal 6.1.176-223.369.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Jul 24 13:34:27 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/home2/cgny/public_html/newadmin/ |
Upload File : |
<cfinclude template="header.cfm">
<link href="../plugins/bower_components/datatables/jquery.dataTables.min.css" rel="stylesheet" type="text/css" />
<link href="https://cdn.datatables.net/buttons/1.2.2/css/buttons.dataTables.min.css" rel="stylesheet" type="text/css" />
<div id="page-wrapper">
<div class="container-fluid">
<div class="row bg-title">
<div class="col-lg-3 col-md-4 col-sm-4 col-xs-12">
<h4 class="page-title">Survey Stats</h4>
<a href="data-table-survey.cfm">Raw Data</a>
</div>
<div class="col-lg-9 col-sm-8 col-md-8 col-xs-12">
<ol class="breadcrumb">
<li><a href="#">Dashboard</a></li>
<li><a href="#">Calendar</a></li> <li class="active">Today</li>
</ol>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /row -->
<div class="row">
<div class="col-sm-12">
<div class="white-box">
<Cfset newdatetime = #dateformat(currentdatetime,'yyyy-mm-dd')#>
<Cfset newdatetime = #dateadd('d',-7,today)#>
<Cfset newdatetime = #dateformat(newdatetime,'yyyy-mm-dd')#>
<Cfset newdatetime = '2021-11-09'>
<cfset today = #dateformat(currentdatetime,'yyyy-mm-dd')#>
<Cfset tomorrow = #dateadd('d',1,today)#>
<cfset tomorrow = #dateformat(tomorrow,'yyyy-mm-dd')#>
<form action="data-table-survey-analyze.cfm?requesttimeout=5000" method="post" name="calme" enctype="multipart/form-data">
<Table><tr><td>
From:
<input class="form-control" id="datepicker-autoclose" placeholder="mm/dd/yyyy" name="dater" label="Block out starts" style="width:115px;" data-date-format="yyyy-mm-dd" <Cfif parameterexists(form.daterend)>value="<cfoutput>#dateformat(dater,'yyyy-mm-dd')#</cfoutput>" <cfelse> value="<cfoutput>#dateformat(newdatetime,'yyyy-mm-dd')#</cfoutput>"</Cfif>>
</Td><td>
To:
<input name="daterend" class="form-control" id="datepicker-autoclose" placeholder="mm/dd/yyyy" style="width:115px;" data-date-format="yyyy-mm-dd" <Cfif parameterexists(form.daterend)>value="<cfoutput>#dateformat(daterend,'yyyy-mm-dd')#</cfoutput>" <cfelse> value="<cfoutput>#dateformat(tomorrow,'yyyy-mm-dd')#</cfoutput>"</Cfif>>
</td><Td style="padding-top: 14px;">
<button class="btn btn-success btn-mini">SEARCH <i class="icon-save"></i></button>
</Td></tr></table>
</form>
<!--- <p class="text-muted m-b-30">Export data to Copy, CSV, Excel, PDF & Print</p>
---> <div class="table-responsive">
<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey <Cfif parameterexists(form.daterend)>where currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery>
<h1> Total Responses: <cfoutput>#getc.counter#</cfoutput>
</h1>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">What are your plans while visiting NYC? (Check all)</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Theater"> Theater <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%theater%' <Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Sightseeing attractions"> Sightseeing attractions <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%sightseeing%' <Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Museums"> Museums <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%museums%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Shopping"> Shopping <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%Shopping%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Historical sites"> Historical sites <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%historical%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Parks"> Parks <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%parks%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Boat ride"> Boat ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%boat%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Helicopter ride"> Helicopter ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%helicopter%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="plansvisit" SIZE="25" value="Nightlife"> Nightlife <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where plansvisit like '%nightlife%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">While in NYC did you purchase tickets to? (Check all)</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whilepurchase" SIZE="25" value="Theater"> Theater <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whilepurchase like '%theater%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whilepurchase" SIZE="25" value="Sightseeing attractions"> Sightseeing attractions<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whilepurchase like '%sightseeing%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whilepurchase" SIZE="25" value="Museums"> Museums<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whilepurchase like '%museums%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whilepurchase" SIZE="25" value="Boat ride"> Boat ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whilepurchase like '%boat%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whilepurchase" SIZE="25" value="Helicopter ride"> Helicopter ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whilepurchase like '%helicopter%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whilepurchase" SIZE="25" value="Nightlife venue"> Nightlife venue <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whilepurchase like '%nightlife%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">Did you purchase tickets to any of these in NYC prior to arriving?
(Check all)</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="checkbox" NAME="didpurchase" SIZE="25" value="Theater"> Theater <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where didpurchase like '%theater%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="didpurchase" SIZE="25" value="Sightseeing attractions"> Sightseeing attractions <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where didpurchase like '%sightseeing%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="didpurchase" SIZE="25" value="Museums"> Museums <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where didpurchase like '%museums%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="didpurchase" SIZE="25" value="Boat ride"> Boat ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where didpurchase like '%boat%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="didpurchase" SIZE="25" value="Helicopter ride"> Helicopter ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where didpurchase like '%helicopter%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="didpurchase" SIZE="25" value="Nightlife venue"> Nightlife venue<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where didpurchase like '%nightlife%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">Did you use AI to help plan your trip to NYC for the following?</label><br>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;" colspan="2"><strong>General planning</strong></td></tr>
<tr><td style="padding:4px;">Yes <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_general like '%yes%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">No <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_general like '%no%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;" colspan="2"><strong>Sightseeing attractions</strong></td></tr>
<tr><td style="padding:4px;">Yes <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_sightseeing like '%yes%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">No <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_sightseeing like '%no%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;" colspan="2"><strong>Broadway show</strong></td></tr>
<tr><td style="padding:4px;">Yes <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_broadway like '%yes%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">No <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_broadway like '%no%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;" colspan="2"><strong>Restaurants</strong></td></tr>
<tr><td style="padding:4px;">Yes <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_restaurants like '%yes%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">No <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_restaurants like '%no%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;" colspan="2"><strong>Museums</strong></td></tr>
<tr><td style="padding:4px;">Yes <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_museums like '%yes%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">No <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_museums like '%no%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;" colspan="2"><strong>Other</strong></td></tr>
<tr><td style="padding:4px;">Yes <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_other like '%yes%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">No <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where ai_other like '%no%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
</table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">Did you purchase any discount tickets?</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="radio" NAME="discountpurchase" SIZE="25" value="Yes"> Yes <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where discountpurchase like '%yes%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="discountpurchase" SIZE="25" value="No"> No <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where discountpurchase like '%no%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">Did you use City Guide to help you choose?
(Check all)</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="checkbox" NAME="usecityguide" SIZE="25" value="Theater"> Theater<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where usecityguide like '%theater%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="usecityguide" SIZE="25" value="Sightseeing attractions"> Sightseeing attractions<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where usecityguide like '%sightseeing%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="usecityguide" SIZE="25" value="Museums"> Museums<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where usecityguide like '%theater%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="usecityguide" SIZE="25" value="Boat ride"> Boat ride<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where usecityguide like '%boat%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="usecityguide" SIZE="25" value="Helicopter ride"> Helicopter ride<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where usecityguide like '%helicopter%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="usecityguide" SIZE="25" value="Nightlife venue"> Nightlife venue <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where usecityguide like '%nightlife%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">What attractions will you visit? (Check all)</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractions" SIZE="25" value="Observatory"> Observatory <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractions like '%observatory%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractions" SIZE="25" value="Museum"> Museum attractions <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractions like '%museum%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractions" SIZE="25" value="Bus tour"> Bus tour <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractions like '%bus%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractions" SIZE="25" value="Boat ride"> Boat ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractions like '%boat%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractions" SIZE="25" value="Helicopter ride"> Helicopter ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractions like '%helicopter%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractions" SIZE="25" value="Indoor Venue"> Indoor Venue <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractions like '%indoor%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">What attractions will you visit? (Check all)</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractionsnew" SIZE="25" value="Observatory"> Observatory <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractionsnew like '%observatory%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractionsnew" SIZE="25" value="Museum"> Museums <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractionsnew like '%museum%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractionsnew" SIZE="25" value="Attraction"> Attractions <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractionsnew like '%Attraction%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractionsnew" SIZE="25" value="Bus tour"> Bus tour <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractionsnew like '%bus%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractionsnew" SIZE="25" value="Boat ride"> Boat ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractionsnew like '%boat%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractionsnew" SIZE="25" value="Helicopter ride"> Helicopter ride <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractionsnew like '%helicopter%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whichattractionsnew" SIZE="25" value="Indoor Venue"> Indoor Venue <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whichattractionsnew like '%indoor%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">Where do you plan to eat? (Check all)</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Gourmet restaurant"> Gourmet restaurant <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%gourmet%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Steak house"> Steak house <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%steak%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Theme restaurant"> Theme restaurant <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%theme%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Italian"> Italian <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%italian%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Chinese"> Chinese <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%chinese%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Thai"> Thai <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%thai%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Korean"> Korean <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%korean%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Pre-Theater"> Pre-theater <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%pre-theater%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Brunch"> Brunch <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%brunch%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;"><br>
<binput type="checkbox" NAME="whereeat" SIZE="25" value="Rooftop"> Rooftop <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whereeat like '%rooftop%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">Where are you traveling from?</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="radio" NAME="wherefrom" SIZE="25" value="USA"> USA <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherefrom like '%USA%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherefrom" SIZE="25" value="Europe"> Europe <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherefrom like '%Europe%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherefrom" SIZE="25" value="Australia/New Zealand"> Australia/New Zealand <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherefrom like '%Australia%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherefrom" SIZE="25" value="Latin America"> Latin America<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherefrom like '%latin%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherefrom" SIZE="25" value="Canada"> Canada <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherefrom like '%canada%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherefrom" SIZE="25" value="Mexico"> Mexico <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherefrom like '%Mexico%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherefrom" SIZE="25" value="Asia"> Asia <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherefrom like '%Asia%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">How many are in your traveling party?
</label><Br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
1 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where partycount like '%1%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></option>
</td></tr><tr><Td style="padding:4px;">
2 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where partycount like '%2%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput> </td></tr><tr><Td style="padding:4px;">
3 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where partycount like '%4%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput> </td></tr><tr><Td style="padding:4px;">
4 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where partycount like '%4%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput> </td></tr><tr><Td style="padding:4px;">
5+ <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where partycount like '%5%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput> </td></tr><tr><Td style="padding:4px;">
Group <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where partycount like '%group%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput> </td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">How often have you been to NYC?</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="radio" NAME="timesinnyc" SIZE="25" value="First time"> First time <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where timesinnyc like '%first%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="timesinnyc" SIZE="25" value="2"> 2 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where timesinnyc like '%2%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="timesinnyc" SIZE="25" value="3"> 3<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where timesinnyc like '%3%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="timesinnyc" SIZE="25" value="4 or more"> 4 or more<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where timesinnyc like '%4%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">How many days are you staying in NYC?</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="radio" NAME="daysstaying" SIZE="25" value="1-2 days"> 1-2 days <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where daysstaying like '%1-2%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="daysstaying" SIZE="25" value="3-5 days"> 3-5 days<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where daysstaying like '%3-5%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="daysstaying" SIZE="25" value="6-8 days"> 6-8 days<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where daysstaying like '%6-8%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="daysstaying" SIZE="25" value="9 days or more"> 9 days or more<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where daysstaying like '%9%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">When did you make your decision to come to NYC?</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="radio" NAME="whendecide" SIZE="25" value="Within the last week"> Within the last week<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whendecide like '%last week%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="whendecide" SIZE="25" value="Within the last month"> Within the last month<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whendecide like '%within%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="whendecide" SIZE="25" value="2-6 months"> 2-6 months<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whendecide like '%2-6%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="whendecide" SIZE="25" value="6-12 months"> 6-12 months<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whendecide like '%6-12%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="whendecide" SIZE="25" value="Over 1 year"> Over 1 year<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where whendecide like '%over 1 year%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">Where are you staying while in NYC?</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="radio" NAME="wherestaying" SIZE="25" value="Luxury hotel"> Luxury hotel <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherestaying like '%luxury%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherestaying" SIZE="25" value="Moderate hotel"> Moderate hotel <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherestaying like '%moderate%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherestaying" SIZE="25" value="Airbnb"> Airbnb <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherestaying like '%airbnb%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherestaying" SIZE="25" value="Friend/family"> Friend/family<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherestaying like '%friend%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="wherestaying" SIZE="25" value="Other"> Other <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where wherestaying like '%other%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">How much do you expect to spend while in NYC? (Exclude accommodations and transportation)</label><br>
<table border="1" cellpadding="4" cellspacing="0"><tr><td style="padding:4px;">
<binput type="radio" NAME="howmuchspend" SIZE="25" value="<$500"> <$500 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where howmuchspend = '<$500'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="howmuchspend" SIZE="25" value="$501-1,000"> $501-1,000<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where howmuchspend = '$501-1,000'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="howmuchspend" SIZE="25" value="$1,001-2,500"> $1,001-2,500 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where howmuchspend = '$1,001-2,500'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="howmuchspend" SIZE="25" value="$2,501-5,000"> $2,501-5,000 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where howmuchspend = '$2,501-5,000'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr><tr><td style="padding:4px;">
<binput type="radio" NAME="howmuchspend" SIZE="25" value=">$5,001 "> >$5,001 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where howmuchspend = '>$5,001'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr></table>
</div></div>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb">What is your age?</label><br>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><25 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where age = '<25' <Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput>
</td></tr><tr><td style="padding:4px;">
26-35 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where age = '26-35'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput>
</td></tr><tr><td style="padding:4px;">
44-55<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where age = '44-55'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput>
</td></tr><tr><td style="padding:4px;">
56-65<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where age = '56-65'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput>
</td></tr><tr><td style="padding:4px;">
66-74 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where age = '66-74'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput>
</td></tr><tr><td style="padding:4px;">
75+ <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where age = '75+'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput>
</td></tr></table>
<div class="col-lg-12">
<div class="form-group">
<label for="blurb"> New Age</label><br></td></tr>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><25 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where agenew like '%<25%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">25-34 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where agenew like '%34%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">35-44 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where agenew like '%44%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">45-54 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where agenew like '%54%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">55-64 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where agenew like '%64%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">65-74 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where agenew like '%74%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;">75+ <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurvey where agenew like '%75%'<Cfif parameterexists(form.daterend)> and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif></cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
</table>
</div></div>
<br>
<label for="blurb">Source</label><br>
<cfquery name="getsource" dataSource="#ds#">
select sourcecode, count(sourcecode) as counter from cgsurvey <Cfif parameterexists(form.daterend)>where currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif> group by sourcecode
</cfquery>
<table border="1" cellpadding="4" cellspacing="0">
<cfoutput query="getsource">
<tr><td style="padding:4px;">
#sourcecode#
</td><td style="padding:4px;">
#counter#
</td></tr>
</cfoutput>
</table>
</div></div>
<br>
<label for="blurb">Open ended</label><br>
<cfquery name="getsource" dataSource="#ds#">
select helpplan from cgsurvey where helpplan is not null
and helpplan <> ''
<Cfif parameterexists(form.daterend)>and currentdatetime >= '#form.dater#' and currentdatetime <= '#daterend#'</cfif>
</cfquery>
<table border="1" cellpadding="4" cellspacing="0">
<cfoutput query="getsource">
<tr><td style="padding:4px;" colspan="2">
#helpplan#
</td></tr>
</cfoutput>
</table>
</div></div>
</div>
</div>
</div>
</div>
<!-- /.row -->
<cfinclude template="footer.cfm">
<script src="../plugins/bower_components/datatables/jquery.dataTables.min.js"></script>
<!-- jQuery -->
<script src="../plugins/bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="bootstrap/dist/js/bootstrap.min.js"></script>
<!-- Menu Plugin JavaScript -->
<script src="../plugins/bower_components/sidebar-nav/dist/sidebar-nav.min.js"></script>
<!--slimscroll JavaScript -->
<script src="js/jquery.slimscroll.js"></script>
<!--Wave Effects -->
<script src="js/waves.js"></script>
<!-- Custom Theme JavaScript -->
<script src="js/custom.min.js"></script>
<!-- Plugin JavaScript -->
<script src="../plugins/bower_components/moment/moment.js"></script>
<!-- Clock Plugin JavaScript -->
<script src="../plugins/bower_components/clockpicker/dist/jquery-clockpicker.min.js"></script>
<!-- Color Picker Plugin JavaScript -->
<script src="../plugins/bower_components/jquery-asColorPicker-master/libs/jquery-asColor.js"></script>
<script src="../plugins/bower_components/jquery-asColorPicker-master/libs/jquery-asGradient.js"></script>
<script src="../plugins/bower_components/jquery-asColorPicker-master/dist/jquery-asColorPicker.min.js"></script>
<!-- Date Picker Plugin JavaScript -->
<script src="../plugins/bower_components/bootstrap-datepicker/bootstrap-datepicker.min.js"></script>
<!-- Date range Plugin JavaScript -->
<script src="../plugins/bower_components/timepicker/bootstrap-timepicker.min.js"></script>
<script src="../plugins/bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<script>
// Clock pickers
$('#single-input').clockpicker({
placement: 'bottom',
align: 'left',
autoclose: true,
'default': 'now'
});
$('.clockpicker').clockpicker({
donetext: 'Done',
})
.find('input').change(function(){
console.log(this.value);
});
$('#check-minutes').click(function(e){
// Have to stop propagation here
e.stopPropagation();
input.clockpicker('show')
.clockpicker('toggleView', 'minutes');
});
if (/mobile/i.test(navigator.userAgent)) {
$('input').prop('readOnly', true);
}
// Colorpicker
$(".colorpicker").asColorPicker();
$(".complex-colorpicker").asColorPicker({
mode: 'complex'
});
$(".gradient-colorpicker").asColorPicker({
mode: 'gradient'
});
// Date Picker
jQuery('.mydatepicker, #datepicker').datepicker();
jQuery('#datepicker-autoclose').datepicker({
autoclose: true,
todayHighlight: true
});
jQuery('#date-range').datepicker({
toggleActive: true
});
jQuery('#datepicker-inline').datepicker({
todayHighlight: true
});
// Daterange picker
$('.input-daterange-datepicker').daterangepicker({
buttonClasses: ['btn', 'btn-sm'],
applyClass: 'btn-danger',
cancelClass: 'btn-inverse'
});
$('.input-daterange-timepicker').daterangepicker({
timePicker: true,
format: 'MM/DD/YYYY h:mm A',
timePickerIncrement: 30,
timePicker12Hour: true,
timePickerSeconds: false,
buttonClasses: ['btn', 'btn-sm'],
applyClass: 'btn-danger',
cancelClass: 'btn-inverse'
});
$('.input-limit-datepicker').daterangepicker({
format: 'MM/DD/YYYY',
minDate: '06/01/2015',
maxDate: '06/30/2015',
buttonClasses: ['btn', 'btn-sm'],
applyClass: 'btn-danger',
cancelClass: 'btn-inverse',
dateLimit: {
days: 6
}
});
</script>
<!--Style Switcher -->
<script src="../plugins/bower_components/styleswitcher/jQuery.style.switcher.js"></script>
</body>
</html>