<%@ language="vbscript" %> <% buildingID= Request.querystring("buildingID") set wredb = server.createobject("adodb.connection") wredb.open "wre" set prodinfoset = wredb.execute("select * from buildings where buildingID = "&buildingID) if prodinfoset.eof then response.write "Please go back and make sure you clicked on the proper link." else address = prodinfoset("address") city = prodinfoset("city") state = prodinfoset("state") zip = prodinfoset("zip") srent = prodinfoset("srent") onerent = prodinfoset("onerent") tworent = prodinfoset("tworent") threerent = prodinfoset("threerent") fourrent = prodinfoset("fourrent") fiverent = prodinfoset("fiverent") s = prodinfoset("s") oneb = prodinfoset("oneb") twob = prodinfoset("twob") threeb = prodinfoset("threeb") fourb = prodinfoset("fourb") fiveb = prodinfoset("fiveb") term = prodinfoset("term") bathrooms = prodinfoset("bathrooms") pets = prodinfoset("pets") image = prodinfoset("image") phone = prodinfoset("phone") fax = prodinfoset("fax") %> <%=address%>
<%=address%>
<%=city%>, <%=state%> <%=zip%>
Amenities:

Bedrooms: <% if s > 0 then response.write "Studio, " end if if oneb > 0 then response.write "1 Bedroom, " end if if twob > 0 then response.write "2 Bedrooms, " end if if threeb > 0 then response.write "3 Bedrooms, " end if if fourb > 0 then response.write "4 Bedrooms, " end if if fiveb > 0 then response.write "5 Bedrooms" end if %>
Term of Lease: <% if term = "2 Years" then response.write "24 Months" %>
Bathrooms: <%=bathrooms%>
Pets: <%=pets%>

Rent Ranges:

<% if s > 0 then response.write "Studio:           "&srent&"
" end if if oneb > 0 then response.write "1 Bedroom:   "&onerent&"
" end if if twob > 0 then response.write "2 Bedrooms: "&tworent&"
" end if if threeb > 0 then response.write "3 Bedrooms: "&threerent&"
" end if if fourb > 0 then response.write "4 Bedrooms: "&fourrent&"
" end if if fiveb > 0 then response.write "5 Bedrooms: "&fiverent&"
" end if %>

Floorplans:

<% if s > 0 then %> Studios
<% end if if oneb > 0 then %> 1 Bedroom
<% end if if twob > 0 then %> 2 Bedrooms
<% end if if threeb > 0 then %> 3 Bedrooms
<% end if if fourb > 0 then %> 4 Bedrooms
<% end if if fiveb > 0 then %> 5 Bedrooms
<%end if %>
Contact: Leasing Office
Phone: <%=phone%>
Fax: <%=fax%>
<% end if prodinfoset.close set prodinfoset=nothing wredb.close set wredb=nothing %>