National Site
National Site
Home Contact Us Team Points Future Events Completed Events League Info Member Login New Member
About FASA FAQ Rule Book Team Insurance Umpire Registration Player Registration College Registration
Showcase Events West Coast National Northern National Gulf Coast National Class C World Winter World Winter Class C World
College Camps TBD TBD Pensacola FL Mesquite TX Houston Bear Creek Livingston TX
Ark LA TX Challenge Southwestern National Firecracker National Eastern National Spring National Fall National World Series
Shreveport LA Mesquite TX Houston TX Parkersburg WV TBD Gulfport MS Branson MO
Failed to connect to MySQL: php_network_getaddresses: getaddrinfo failed: Name or service not known Tournament Profile

  

  Profile

Back to Pervice Return to Tournament Search Page How to enter Events JOIN THIS EVENT
To See Pool play select the age group below. To see the brackets select the link on the bottom of the pool schedule.
Age Groups  Cost: Start Date: End Date: Sign Up By: Location: GG: Format: Max: Entered: Visits:
,
Complex Complex Address  
Player Sign-up
HOST INFORMATION
Name: Address: City, State: Zip Code: Home: Cell: E-Mail Address:
,
HOTEL INFORMATION
Name Address City State Phone Rate
<% rowcolor="row1" set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.open(server.mappath("fpdb/fast.mdb")) set rs=Server.CreateObject("ADODB.recordset") sql="SELECT tblTeam.TEAMID,tblTeam.TMNAME, tblTeam.TMCITY, tblTeam.TMSTATE, tblTeam.TMAGE,tbljoin.TAGE, tblTeam.POINTSTOTAL,TBLteam.power AS [POWER RATING],tbljoin.place,tbljoin.points as [Points Earned],tblteam.season as [Season],tblteam.paid, tblTeam.WS, tblTeam.ST, tblTeam.NT, tblTeam.RQ, tblteam.rc as RC FROM (tblTournament INNER JOIN tblJoin ON tblTournament.TRNYID = tblJoin.TRNYID) INNER JOIN tblTeam ON tblJoin.TEAMID = tblTeam.TEAMID WHERE [tblJoin.TRNYID]="&request.Querystring("ID")&" AND [tblJoin.TRNYID] Like [TblTournament.TRNYID] AND [tblJoin.TEAMID] Like [tblTeam.TEAMID] ORDER BY tbljoin.TAGE,tblteam.TMNAME" rs.Open sql,conn 'rowcolor="row1" do until rs.EOF 'if rowcolor="row1" then 'rowcolor="row2" 'else 'rowcolor="row1" 'end if if rs.Fields("PAID")=True and rs.Fields("SEASON")=season then rowcolor="tmpaid" end if if rs.Fields("PAID")=False and rs.Fields("SEASON")=season then rowcolor="tmdue" end if if rs.Fields("PAID")=False and rs.Fields("SEASON")=season and rs.Fields("RC")>2 then rowcolor="tmpastdue" end if if rs.Fields("SEASON")<>season then rowcolor="tmreg" end if response.write("") for each x in rs.Fields if x.name = "TMNAME" then response.write("") elseif x.name = "TMCITY" then response.write("") elseif x.name = "TMSTATE" then response.write("") elseif x.name = "TAGE" then response.write("") elseif x.name = "POINTSTOTAL" then response.write("") elseif x.name = "POWER RATING" then 'response.write("") elseif x.name = "place" then response.write("") elseif x.name = "Points Earned" then response.write("") elseif x.name = "Season" then response.write("") elseif x.name = "WS" and trnytype="WS" then if x.value = True then response.write("") else response.write("") end if elseif x.name = "ST" and trnytype="ST" then if x.value = True then response.write("") else response.write("") end if elseif x.name = "NT" and trnytype="NT" then if x.value = True then response.write("") else response.write("") end if elseif x.name = "RQ" and trnytype="RQ" then if x.value = True then response.write("") else response.write("") end if else 'response.write("") end if next rs.MoveNext response.write("") loop rs.Close Conn.close set conn=nothing response.write("
Team Name City State Age Total Points Placed Event Points Season Qualified
" & x.value & " " & x.value & " " & x.value & " " & x.value & " " & x.value & " "& x.value & " " & x.value & "  " & x.value & " " & x.value & "YesNoYesNoYesNoYesNo" & x.value & "
") %>

* Teams in red are teams that have not yet paid the sanction fee*