%@ 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%> <%=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 %>
| ||||