<cfquery name="getreg" dataSource="#ds#">
	select distinct region from camp2018form 
	where region not like '%,%'
</cfquery>
<cfoutput query="getreg">
	<a href="camp2018csv.cfm?gridit=on&region=#region#">#region#</a> | 
</cfoutput>	

<a href="camp2018csv.cfm?gridit=on&region=Rockland/Bergen Parent">Rockland/Bergen Parent</a> 

| <a href="camp2018csv.cfm?gridit=on&region=BAPBPQP">BAP, BP, QP Parent</a> 


<FORM action="camp2018csv.cfm?gridit=on" method="post"  enctype="multipart/form-data" name="MyForm">
<input name="searcher" placeholder="Search">
<input type="submit" Value="Go">

</form>

<Cfquery name="Getcamps" dataSource="#ds#">
	select * from camp2018form
	where 1 = 1
	and disable = 0 
		<Cfif parameterexists(url.region)>
			
						<Cfif  url.region eq 'BAPBPQP'>
	and (region like '%Queens%' or region like '%Apple%' or region like '%Brooklyn%')
<cfelse>
		and region like '%#url.region#%'
	</Cfif>	
	</Cfif>	
	
	
	
			<Cfif parameterexists(form.searcher)>
		and businessname like '%#form.searcher#%'
	</Cfif>	


order by businessname
</cfquery>
<Table cellpadding="4" cellspacing="0" border="1">
<tr><td>id</td>
<td><b>businessname</b></td>
<td><b>region</b></td>
<td><b>accountrep</b></td>
<td><b>address</b></td>

<td><b>website</b></td>

<Cfquery name="Getreg" dataSource="#ds#">
	select catname, reg,id as catid
	from camp2018catmap
</cfquery>

<cfset cat1 = 0>
<cfset cat2 = 0>
<cfset cat3 = 0>
<cfset cat4 = 0>
<cfset cat5 = 0>
<cfset cat6 = 0>
<cfset cat7 = 0>
<cfset cat8 = 0>
<cfset cat9 = 0>
<cfset cat10 = 0>
<cfset cat11 = 0>
<cfset cat12 = 0>
<cfset cat13 = 0>
<cfset cat14 = 0>
<cfset cat15 = 0>
<cfset cat16 = 0>
<cfset cat17 = 0>
<cfset cat18 = 0>
<cfset cat19 = 0>
<cfset cat20 = 0>
<cfset cat21 = 0>
<cfset cat22 = 0>
<cfset cat23 = 0>
<cfset cat24 = 0>
<cfset cat25 = 0>
<cfset cat26 = 0>
<cfset cat27 = 0>
<cfset cat28 = 0>
<cfset cat29 = 0>
<cfset cat30 = 0>


<Cfloop from="1" to="#getreg.recordcount#" index="i">
<cfoutput> 	
<td>
<b>#getreg.reg[i]# - #getreg.catname[i]#</b>	

</td>	</cfoutput>
</Cfloop>		

</tr>

<Cfoutput query="Getcamps">

<tr><td><a href="camp2018.cfm?editone=#id#">#id#</a></td>
<td>#businessname#</td>
<td>#region#</td>
<td>#accountrep#</td>
<td>#address#</td>
<td>#website#</td>

<Cfloop from="1" to="#getreg.recordcount#" index="i">
<td>

<cfquery name="Geter" dataSource="#ds#">
	select * from camp2018formcats
	where campid = #id#
	and catid = #getreg.catid[i]#

</cfquery>

<Cfif #geter.recordcount# gt 0>
1

<cfif  #getreg.catid[i]# eq 1><Cfset cat1 = cat1 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 2><Cfset cat2 = cat2 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 3><Cfset cat3 = cat3 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 4><Cfset cat4 = cat4 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 5><Cfset cat5 = cat5 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 6><Cfset cat6 = cat6 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 7><Cfset cat7 = cat7 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 8><Cfset cat8 = cat8 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 9><Cfset cat9 = cat9 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 10><Cfset cat10 = cat10 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 11><Cfset cat11 = cat11 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 12><Cfset cat12 = cat12 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 13><Cfset cat13 = cat13 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 14><Cfset cat14 = cat14 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 15><Cfset cat15 = cat15 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 16><Cfset cat16 = cat16 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 17><Cfset cat17 = cat17 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 18><Cfset cat18 = cat18 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 19><Cfset cat19 = cat19 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 20><Cfset cat20 = cat20 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 21><Cfset cat21 = cat21 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 22><Cfset cat22 = cat22 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 23><Cfset cat23 = cat23 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 24><Cfset cat24 = cat24 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 25><Cfset cat25 = cat25 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 26><Cfset cat26 = cat26 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 27><Cfset cat27 = cat27 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 28><Cfset cat28 = cat28 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 29><Cfset cat29 = cat29 + 1></Cfif>
<cfif  #getreg.catid[i]# eq 30><Cfset cat30 = cat30 + 1></Cfif>

</Cfif>
</td>	
</Cfloop>		

</tr>

</Cfoutput>


<tr>
<td><b>TOTAL</b></td>	
<td></td>	
<td></td>	
<td></td>	
<td></td>	
<Cfoutput>
<td>#cat1#</td>
<td>#cat2#</td>
<td>#cat3#</td>
<td>#cat4#</td>
<td>#cat5#</td>
<td>#cat6#</td>
<td>#cat7#</td>
<td>#cat8#</td>
<td>#cat9#</td>
<td>#cat10#</td>
<td>#cat11#</td>
<td>#cat12#</td>
<td>#cat13#</td>
<td>#cat14#</td>
<td>#cat15#</td>
<td>#cat16#</td>
<td>#cat17#</td>
<td>#cat18#</td>
<td>#cat19#</td>
<td>#cat20#</td>
<td>#cat21#</td>
<td>#cat22#</td>
<td>#cat23#</td>
<td>#cat24#</td>
<td>#cat25#</td>
<td>#cat26#</td>
<td>#cat27#</td>
<td>#cat28#</td>
<td>#cat29#</td>
<td>#cat30#</td>
 </Cfoutput>
</tr>	

</Table>