<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>
        </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">


<!---            <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 cgsurveyetd</cfquery>
	          
<h1>	          Total Responses: <cfoutput>#getc.counter#</cfoutput>
	</h1>          
	
	
	                                                <div class="form-group"> 
<label for="blurb"> What are your NYC Interests  (Check all)</label><br></td></tr>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Museums"> Museums <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%museums%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>

<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Attractions"> Attractions <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%attractions%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Broadway"> Broadway<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%Broadway%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Off-Broadway"> Off-Broadway<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%off-broadway%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Cultural arts"> Cultural Arts<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%cultural%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Comedy"> Comedy<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%comedy%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Music (Jazz, concerts, etc.)"> Music (Jazz, concerts, etc.)<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%music%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Immersive experiences"> Immersive experiences<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%immersive%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Fairs and Festivals"> Fairs and Festivals<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%fairs%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Talks and Lectures"> Talks and lectures<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%talks%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Gourmet dining"> Gourmet Dining<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%gourmet%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="New restaurant openings"> New Restaurant Openings<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%restaurant%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Tours"> Tours<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%tours%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="nycinterests" SIZE="25" value="Private shopping"> Private Shopping<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where nycinterests like '%private shopping%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
</table>

</div>


 <div class="col-lg-12"> 
         <table border="1" cellpadding="4" cellspacing="0">
                                                <div class="form-group"> 
<label for="blurb"> Would you attend custom, private ETD (Everything To Do) events?
  (Check all)</label><br></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="privateevents" SIZE="25" value="Private Restaurants and dining events"> Private Restaurants and dining events<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where privateevents like '%private restaurants%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="privateevents" SIZE="25" value="Private exhibit openings"> Private exhibit openings<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where privateevents like '%private exhibit%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="privateevents" SIZE="25" value="Theater - behind the scenes"> Theater - behind the scenes<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where privateevents like '%theater%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="privateevents" SIZE="25" value="Curated museum tours"> Curated museum tours<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where privateevents like '%curated%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="privateevents" SIZE="25" value="Private shopping events"> Private shopping events<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where privateevents like '%private shopping%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="privateevents" SIZE="25" value="Behind the scenes attraction tours"> Behind the scenes attraction tours<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where privateevents like '%attraction%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
</table>


</div>

<br>
<Br><p>&nbsp;</p>
 <div class="col-lg-12"> 
                                                <div class="form-group"> 
<label for="blurb"> What are the highest prices are you comfortable spending to attend private events?</label><br></td></tr>

<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="radio" NAME="highestprices" SIZE="25" value="< $50"> < $50<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where highestprices like '%< $50%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="highestprices" SIZE="25" value="$50-100"> $50-100<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where highestprices like '%50-100%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="highestprices" SIZE="25" value="$100-150"> $100-150<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where highestprices like '%100-150%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="highestprices" SIZE="25" value="$150-250"> $150-250<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where highestprices like '%150-250%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="highestprices" SIZE="25" value="> $250"> > $250<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where highestprices like '%> 250%'</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"> Are you interested in getting special discount offers?
</label><br></td></tr>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="radio" NAME="discountoffers" SIZE="25" value="Yes">  Yes <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where discountoffers like '%yes%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio"  NAME="discountoffers" SIZE="25" value="No">  No <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where discountoffers like '%no%'</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"> Which discounts are appealing to you?
 
  (Check all)</label><br></td></tr>
  <table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Dining"> Dining <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%dining%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Attractions"> Attractions  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%attractions%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Museums"> Museums <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%museums%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Theater"> Theater  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%theater%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Shopping"> Shopping <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%shopping%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Tours"> Tours <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%tours%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Nightlife"> Nightlife <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%nightlife%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Comedy"> Comedy  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%comedy%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="checkbox" NAME="whatdiscounts" SIZE="25" value="Music"> Music  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where whatdiscounts like '%music%'</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"> Gender</label><br></td></tr>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="radio" NAME="gender" SIZE="25" value="M">  M <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where gender like '%m%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="gender" SIZE="25" value="F">  F  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where gender like '%F%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="gender" SIZE="25" value="Non-Binary">  Non-Binary  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where gender like '%non-binary%'</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"> Age</label><br></td></tr>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="<25"> <25 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where age like '%<25%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="25-34"> 25-34 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where age like '%34%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="35-49"> 35-49  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where age like '%49%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="50-64"> 50-64 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where age like '%50%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="> 65"> >65 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where age like '%65%'</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"> New Age</label><br></td></tr>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="<25"> <25 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where agenew like '%<25%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="25-34"> 25-34 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where agenew like '%34%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>

<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="25-34"> 35-44 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where agenew like '%44%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>

<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="35-49"> 45-54  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where agenew like '%54%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="50-64"> 55-64 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where agenew like '%64%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="> 65"> >65-74 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where agenew like '%74%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="age" SIZE="25" value="> 75+"> >75+ <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where agenew like '%75%'</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"> Family Unit</label><br></td></tr>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="radio" NAME="familyunit" SIZE="25" value="Single"> Single <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where familyunit like '%single%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="familyunit" SIZE="25" value="Married-no children at home"> Married-no children at home  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where familyunit like '%no children%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="familyunit" SIZE="25" value="Married with young children"> Married with young children  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where familyunit like '%young children%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="familyunit" SIZE="25" value="Married with teens"> Married with teens  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where familyunit like '%teens%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="familyunit" SIZE="25" value="Serious relationship"> Serious relationship  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where familyunit like '%serious%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="familyunit" SIZE="25" value="Rather not say"> Rather not say  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where familyunit like '%not say%'</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 family's household income?</label><br></td></tr>
<table border="1" cellpadding="4" cellspacing="0">
<tr><td style="padding:4px;"><input type="radio" NAME="income" SIZE="25" value="<$75,000"> <$75,000  <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where income like '%<$75,000%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="income" SIZE="25" value="$75,000-125,000"> $75,000-125,000 <cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where income like '%$75,000-125,000%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="income" SIZE="25" value="$125,000-200,000"> $125,000-200,000<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where income like '%$125,000-200,000%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="income" SIZE="25" value="$200,000-300,000"> $200,000-300,000<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where income like '%$200,000-300,000%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>
<tr><td style="padding:4px;"><input type="radio" NAME="income" SIZE="25" value="> $300,000"> >$300,000<cfquery name="Getc" dataSource="#ds#">select count(id) as counter from cgsurveyetd where income like '%>$300,000%'</cfquery></td><td style="padding:4px;"><Cfoutput>#getc.counter#</Cfoutput></td></tr>

</table>

</div></div>


	          
	          
	          
            </div>
          </div>
        </div>
      </div>






      <!-- /.row -->

     <cfinclude template="footer.cfm">

<script src="../plugins/bower_components/datatables/jquery.dataTables.min.js"></script>

<!-- start - This is for export functionality only -->
<script src="https://cdn.datatables.net/buttons/1.2.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.flash.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
<script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js"></script>
<script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.print.min.js"></script>
<!-- end - This is for export functionality only -->
<!-- end - This is for export functionality only -->

<script>
    $(document).ready(function(){
      $('#myTable').DataTable();
      $(document).ready(function() {
        var table = $('#example').DataTable({
          "columnDefs": [
          { "visible": false, "targets": 2 }
          ],
          "order": [[ 2, 'asc' ]],
          "displayLength": 25,
          "drawCallback": function ( settings ) {
            var api = this.api();
            var rows = api.rows( {page:'current'} ).nodes();
            var last=null;

            api.column(2, {page:'current'} ).data().each( function ( group, i ) {
              if ( last !== group ) {
                $(rows).eq( i ).before(
                  '<tr class="group"><td colspan="5">'+group+'</td></tr>'
                  );

                last = group;
              }
            } );
          }
        } );

    // Order by the grouping
    $('#example tbody').on( 'click', 'tr.group', function () {
      var currentOrder = table.order()[0];
      if ( currentOrder[0] === 2 && currentOrder[1] === 'asc' ) {
        table.order( [ 2, 'desc' ] ).draw();
      }
      else {
        table.order( [ 2, 'asc' ] ).draw();
      }
    });
  });
    });
    $('#example23').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    });


  </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>