<cfinclude template="header.cfm">


<div id="content">
  <div id="content-header">
  </div>
  <div class="container-fluid" style="margin-left:200px;">

					<table border="0" cellpadding="8" cellspacing="0" width="100%">
					<tr>
					<Td style="padding:5px;"  valign="top">

<span class="header">All Listings</span></strong><br>
<cfoutput><table width=100% cellspacing=0 cellpadding=0 bgcolor=#color#><tr><Td style="padding:5px;" ></td></tr></table></cfoutput>

<div style="margin:15px 0;">
<strong>Jump to category:</strong>
<span style="font-size:12px;">
	<a href="#beautyhealth">Beauty &amp; Health</a> |
	<a href="#carservices">Car Services</a> |
	<a href="#culturalarts">Cultural Arts</a> |
	<a href="#familyfun">Family Fun</a> |
	<a href="#museums">Museums</a> |
	<a href="#nightlife">Nightlife</a> |
	<a href="#restaurants">Restaurants</a> |
	<a href="#shopping">Shopping</a> |
	<a href="#theater">Theater</a> |
	<a href="#toursattractions">Tours &amp; Attractions</a>
</span>
</div>


<form name="validate" action="listall.cfm" method="post" style="margin-bottom:0; display: inline;padding:0; border:0; margin:0" onsubmit="return _CF_checkvalidate(this)"><input name="name" id="Crit1_Value" type="text" size="18"  />
<input name="neighborhood" type="hidden" Value="All">&nbsp;
<INPUT type=submit value="Search Names" name="butt1">
<INPUT type=submit value="Search Names + Descriptions"  name="butt2">

</form>



<table width=98%><tr><Td style="padding:5px;"  valign=top>


<cfset ns = ''>
<cfif parameterexists(form.neighborhood) and #form.neighborhood# is not 'All'>
<cfquery name="getnb" datasource="#ds#">
select *
from Neighborhood
where neighborhood = '#form.neighborhood#'
</cfquery>

<p>

<cfloop index="z" from="1" to="#getnb.recordcount#" step="1">
<cfset ns = #ns# & '#getnb.zip[z]# or zip = '>
</cfloop>
<cfset z= len(#ns#)>
<cfset z=z-9>
<cfif right(#ns#,10) eq ' or zip = '>
<cfset ns = #left(ns,z)#>
</cfif>
</cfif>

<font face=verdana size=-1>
<CFQUERY name="wb" datasource="#ds#">
select BeautyHealth.id,BeautyHealth.name,BeautyHealth.address,BeautyHealth.zip,BeautyHealth.description,BeautyHealth.catid,BeautyHealth.fulldescription,CatBeautyHealth.Cat,CatBeautyHealth.CatDescription
from BeautyHealth inner join CatBeautyHealth
on BeautyHealth.CatID = CatBeautyHealth.CatID
where lastupdated > '2005-10-09 00:00:01'

<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>

<p>

<strong id="beautyhealth">Beauty & Health: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=BeautyHealth">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->
</cfoutput>
</ul>


<CFQUERY name="wb" datasource="#ds#">
select CarServices.id,CarServices.name,CarServices.address,CarServices.zip,CarServices.description,CarServices.catid,CarServices.fulldescription,CatCarServices.Cat,CatCarServices.CatDescription
from CarServices inner join CatCarServices
on CarServices.CatID = CatCarServices.CatID
where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>

<p>
<strong id="carservices">Car Services: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=CarServices">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->
</cfoutput>
</ul>


<CFQUERY name="wb" datasource="#ds#">
select CulturalArts.id,CulturalArts.name,CulturalArts.address,CulturalArts.zip,CulturalArts.description,CulturalArts.catid,CulturalArts.fulldescription,CatCulturalArts.Cat,CatCulturalArts.CatDescription
 from CulturalArts inner join CatCulturalArts
on CulturalArts.CatID = CatCulturalArts.CatID
where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>


<p>
<strong id="culturalarts">Cultural Arts: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=CulturalArts">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->
</cfoutput>
</ul>

<CFQUERY name="wb" datasource="#ds#">
select FamilyFun.id,FamilyFun.name,FamilyFun.address, FamilyFun.zip,FamilyFun.description,FamilyFun.catid,FamilyFun.fulldescription,CatFamilyFun.Cat,CatFamilyFun.CatDescription
 from FamilyFun inner join CatFamilyFun
on FamilyFun.CatID = CatFamilyFun.CatID
where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>


<p>
<strong id="familyfun">Family Fun: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=FamilyFun">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->

</cfoutput>
</ul>



<CFQUERY name="wb" datasource="#ds#">
select Museums.id,Museums.name,Museums.address,Museums.zip,Museums.description,Museums.catid,Museums.fulldescription,CatMuseums.Cat,CatMuseums.CatDescription
 from Museums inner join CatMuseums
on Museums.CatID = CatMuseums.CatID
where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>

<p>
<strong id="museums">Museums: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=Museums">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->
</cfoutput>
</ul>


<CFQUERY name="wb" datasource="#ds#">
select Nightlife.id,Nightlife.name,Nightlife.address,Nightlife.zip,Nightlife.description,Nightlife.catid,Nightlife.fulldescription,CatNightlife.Cat,CatNightlife.CatDescription
 from Nightlife inner join CatNightlife
on Nightlife.CatID = CatNightlife.CatID
where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>

<p>
<strong id="nightlife">Nightlife: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=Nightlife">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->
</cfoutput>
</ul>




<CFQUERY name="wb" datasource="#ds#">
select Restaurants.id,Restaurants.name,Restaurants.address, Restaurants.zip,Restaurants.description,Restaurants.catid,Restaurants.fulldescription,CatRestaurants.Cat,CatRestaurants.CatDescription
 from Restaurants inner join CatRestaurants
on Restaurants.CatID = CatRestaurants.CatID

where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>


<p>
<strong id="restaurants">Restaurants: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=Restaurants">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->
</cfoutput>
</ul>

<CFQUERY name="wb" datasource="#ds#">
select Shopping.id,Shopping.name,Shopping.address,Shopping.zip,Shopping.description,Shopping.catid,Shopping.fulldescription,CatShopping.Cat,CatShopping.CatDescription
 from Shopping inner join CatShopping
on Shopping.CatID = CatShopping.CatID
where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>


<p>
<strong id="shopping">Shopping: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=Shopping">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->

</cfoutput>
</ul>


<CFQUERY name="wb" datasource="#ds#">
select Theater.id,Theater.name,Theater.address,Theater.zip,Theater.description,Theater.catid,Theater.fulldescription,CatTheater.Cat,CatTheater.CatDescription
 from Theater inner join CatTheater
on Theater.CatID = CatTheater.CatID
where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>

<p>
<strong id="theater">Theater: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=Theater">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->
</cfoutput>
</ul>


<CFQUERY name="wb" datasource="#ds#">
select ToursAttractions.id,ToursAttractions.name,ToursAttractions.address,ToursAttractions.zip,ToursAttractions.description,ToursAttractions.catid,ToursAttractions.fulldescription,CatToursAttractions.Cat,CatToursAttractions.CatDescription
 from ToursAttractions inner join CatToursAttractions
on ToursAttractions.CatID = CatToursAttractions.CatID where 1 = 1
<Cfif parameterexists(form.name)> and( name like '%#form.name#%' <cfif ParameterExists(form.butt2)>or fulldescription like '%#form.name#%'</cfif>)</cfif>

order by name
</CFQUERY>

<p>
<strong id="toursattractions">Tours and Attractions: </strong>
<p>
<ul>
<cfoutput query="wb">
<li><strong><a href="listingsedit.cfm?id=#wb.id#&table=ToursAttractions">#name#</a></strong><br>
#address#<!---<br>#fulldescription#--->

</cfoutput>
</ul>



</ul>

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