Good morning
I need to know how I can exclude certain rows if a criteria
is not specified.
I am developing a property management website. On this
website are 1, 2 & 3 bedroom apartment listings. When a person
goes on to the site, they will choose how many bedrooms they are
looking for.
When they press the submit button, they will be taken to the
appropriate page where all the available bedrooms will show. The
only problem with this page is that it shows “all” of
the bedrooms, including the ones that are
“unavailable”. Is there any way to not show an
apartment if it is designated in my database as
”unavailable” ? the link to the website is
http://www.fulloccupancy.net/Form_Master_Apartment.cfm
Below is the code I inputted on my action page:
<cfquery name="Apt_Results"
datasource="BD_Foproperties">
SELECT FOUnitDescription.Location,
FOUnitDescription.PropertyName, FOUnitDescription.Available,
FOUnitDescription.Amenity, FOUnitDescription.Address,
FOUnitDescription.UnitNumber, FOUnitDescription.Bedroom,
FOUnitDescription.Bathroom, FOUnitDescription.SquareFootage,
FOUnitDescription.Rent
FROM FOUnitDescription
WHERE 0=0
AND bedroom
AND bathroom
AND Available<>unavailable
<!--- If Query Begin--->
<cfif bedroom IS NOT "">
AND Bedroom LIKE '%#bedroom#%'
</cfif>
<cfif bathroom IS NOT "">
AND Bathroom LIKE '%#bathroom#%'
</cfif>
<!---If Query End--->
ORDER BY FOUnitDescription.SquareFootage DESC, Rent DESC
</cfquery>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8" />
<title>Apartment Search Results</title>
<script src="Scripts/AC_RunActiveContent.js"
type="text/javascript"></script>
<link href="CSS/FullOccupancyContainer.css"
rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
background-image: url(Image/Pattern3.jpg);
background-repeat: repeat;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
-->
</style>
<link href="CSS/Footer.css" rel="stylesheet"
type="text/css" />
<style type="text/css">
<!--
.style10 {
color: #000000;
font-weight: bold;
}
.style14 {color: #000000}
.style15 {color: #BBE1F2}
-->
</style>
</head>
<body><br /><br />
<!---Header--->
<cfinclude template="Header.cfm">
<!---Header End--->
<div id="THCCOntainer">
<cfinclude template="NavBar.cfm">
<div id="Image Banner"><img name=""
src="Image/Banner_Static/Banner2.jpg" width="780" height="234"
alt="" /></div>
<div id="BeigeHorizontalBarTop"></div>
<div id="SideBarlinks">
<ul>
<span class="SideBarHeader1"></span>
<li><a href="Form_Master.cfm"
class="SideBarlinks">Find an Apartment</a></li>
<li class="style2">News Clippings</li>
<li><a href=""
class="SideBarlinks">Testimonials</a></li>
</ul>
</div>
<div id="Body">
<p class="BodyHeader1"> </p>
<p>
<!---Display Apartment---><span
class="FO_Header1">Apartment Listings...
</span>
<br />
<br />
<cfoutput query="Apt_Results">
<span
class="FO_Header1_SmallFont"></span><span
class="FO_Header1_SmallFont">#CurrentRow#).</span><br
/>
<table width="501" border="0" cellspacing="0"
cellpadding="0">
<tr>
<td valign="top" class="FO_Regular_Grey"
scope="col"> </td>
<td scope="col"><span
class="FO_Header1_SmallFont"> </span> <span
class="FO_Regularbold"><strong> Apartment:
</strong></span><span
class="PropertyName"><span
class="FO_Header1_SmallFont"><span class="FO_Regularbold">
#Apt_Results.UnitNumber#</span></span></span> at
#Apt_Results.Address#</td>
</tr>
<tr>
<td width="129" valign="top" class="FO_Regular_Grey"
scope="col"><strong></strong>
<div align="left"
class="FO_Regular">Feature</div></td>
<td width="372" scope="col"><div align="left"
class="FO_Header1_SmallFont"><span class="AvailiableText">
#Apt_Results.Bedroom#Bed, #Apt_Results.Bathroom#Bath
</span></div></td>
</tr>
<tr>
<td valign="top" class="FO_Regular">Located
at:</td>
<td class="FO_Regular">#Apt_Results.Address#,
Richmond, VA</td>
</tr>
<tr>
<td valign="top" class="FO_Regular style14">Square
Footage:</td>
<td class="FO_Regular"><div align="left"
class="FO_Regular style14"> #Apt_Results.SquareFootage#
Sqft.</div></td>
</tr>
<tr>
<td valign="top" class="style14"> </td>
<td class="FO_Regular style14"> </td>
</tr>
<tr>
<td valign="top" class="style14">Rent:</td>
<td class="FO_Regular style14">Please Call us to get
current rental
info.<!---$#Apt_Results.Rent#/Month---></td>
</tr>
<tr>
<td valign="top"> </td>
<td class="style14"> </td>
</tr>
<tr>
<td height="55" valign="top" class="FO_Regular
style14">Amenities: </td>
<td valign="top" class="FO_Regular
style14">#Apt_Results.Amenity#</td>
</tr>
<tr>
<td height="26" valign="top"
class="style10"> </td>
<td valign="top" class="FO_Header2_Orange"></td>
</tr>
</table>
<span class="FO_Regular">For more info on
#Apt_Results.UnitNumber#, p</span><span
class="FO_Regular">lease Call: <strong>804-643-0534
Ext.12</strong></span><br />
<span
class="style15">_______________________________________________________________________</span><br
/>
</cfoutput>
<!--- End --->
</div>
<div class="clear" id="BeigeHorizontalBar">
</div>
<!---Footer--->
<cfinclude template="Footer.cfm">
<!---Footer End--->
</div>
</html>
1
Reply
AdChoices