Stadiums Display

<% vpage="stadiums" %> <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit. FP_LCID = 1033 %> <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit. FP_CharSet = "windows-1252" FP_CodePage = 1252 %> Stadiums Display

	SportsMedia.net
	[ Home ] [ Products ] [ Services ][ Media Kit ] [ Maps ] [ Press Room ]

Stadiums and Arenas

Facilities listed in color:

Hot Properties

Currently Available

Currently Unavailable

<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM facility WHERE (City LIKE '%::City::%' AND Team LIKE '%::Team::%' AND State LIKE '::State::%' AND Facility LIKE '::Facility::%' AND Sport LIKE '%::Sport::%') ORDER BY Sport DESC, Team ASC,State ASC,Facility ASC" fp_sDefault="Team=&State=&Facility=&Sport=" fp_sNoRecords="" fp_sDataConn="facility" fp_iMaxRecords=2500 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_sColTypes="&ID=3&State=202&Team=202&Sport=202&City=202&Facility=202&Seats=5&YearBuilt=202&Attendance=202&" fp_iDisplayCols=8 fp_fCustomQuery=True BOTID=0 fp_iRegion=BOTID %>

Team	Sport	Facility	City	State	Seats	2005 Attendance	Year Built
No records returned.
<% if FP_FieldVal(fp_rs,"Web") <> " " then a="" else a="" %> <% if FP_FieldVal(fp_rs,"Avail") = "2" then a=a + "" else if FP_FieldVal(fp_rs,"Avail") = "1" then a=a + "" else a=a + "" %> <%=a%> <%=FP_FieldVal(fp_rs,"Team")%> <% if FP_FieldVal(fp_rs,"Web") <> " " then aa="" else aa="" %> <%=aa%>	<% if FP_FieldVal(fp_rs,"Avail") = "2" then t="#008080" else if FP_FieldVal(fp_rs,"Avail") = "1" then t="#ff0000" else t="#000000" %> <%=FP_FieldVal(fp_rs,"Sport")%>	<% if FP_FieldVal(fp_rs,"WebFacility") <> " " then ab="" else ab="" %> <% if FP_FieldVal(fp_rs,"Avail") = "2" then ab=ab + "" else if FP_FieldVal(fp_rs,"Avail") = "1" then ab=ab + "" else ab=ab + "" %> <%=ab%> <%=FP_FieldVal(fp_rs,"Facility")%> <% if FP_FieldVal(fp_rs,"WebFacility") <> " " then aab="" else aab="" %> <%=aab%>	<% if FP_FieldVal(fp_rs,"Avail") = "2" then t="#008080" else if FP_FieldVal(fp_rs,"Avail") = "1" then t="#ff0000" else t="#000000" %> <%=FP_FieldVal(fp_rs,"City")%>	<% if FP_FieldVal(fp_rs,"Avail") = "2" then t="#008080" else if FP_FieldVal(fp_rs,"Avail") = "1" then t="#ff0000" else t="#000000" %> <%=FP_FieldVal(fp_rs,"State")%>	<% if FP_FieldVal(fp_rs,"Avail") = "2" then t="#008080" else if FP_FieldVal(fp_rs,"Avail") = "1" then t="#ff0000" else t="#000000" %> <%=FP_FieldVal(fp_rs,"Seats")%>	<% if FP_FieldVal(fp_rs,"Avail") = "2" then t="#008080" else if FP_FieldVal(fp_rs,"Avail") = "1" then t="#ff0000" else t="#000000" %> <%=FP_FieldVal(fp_rs,"Attendance")%>	<% if FP_FieldVal(fp_rs,"Avail") = "2" then t="#008080" else if FP_FieldVal(fp_rs,"Avail") = "1" then t="#ff0000" else t="#000000" %> <%=FP_FieldVal(fp_rs,"YearBuilt")%>