| The Baseball Cube Site Renovation. | About Us - Sponsor a Page - Contact Us |
| Players | Teams | Draft | Minor Leagues | College | High Schools | Stats Machine | Managers | Posters | Links | MVN Blogs | Advertising |
 |
|
| NFL Tickets, MLB Tickets, Red Sox Tickets, NY Yankees Tickets, World Series Tickets, Cubs Tickets, Patriots Tickets and Steelers Tickets. |
| John Mayer Tickets, Bob Dylan Tickets – Jersey Boys Tickets, Jimmy Buffett Tickets, Cardinals Tickets, Red Sox Tickets, New York Yankees Tickets, White Sox Tickets. |
TBC SHOP
Friends of TBC
|
| ||||||||||||||||||||||||||||||
|
| About TBC | Privacy Policy | Sponsorships | Suggestions | Contact Us |
| " response.write "High School Info" response.write " |
"
response.write " Baseball Alumni"
response.write " |
| "
response.write " Drafted Players"
response.write " |
| "
response.write " " & RegionName & " High Schools"
response.write " |
| "
response.write " High School Index"
response.write " |
" end sub sub showaka '+++ SHOW ALTERNATE NAMES FOR HIGH SCHOOL +++++++++++++++++++++ 'Only if exists. if aka <> "" then response.write "
" response.write "AKA: " & aka & " High School" response.write "
Baseball Alumni - Drafted Players - <%Call other_HS%>
The following list contains all players known to The Baseball Cube to have played at this high school and then gone on to play college ball or better. It is by no means complete and if you know of any players who went on to play professional baseball who you believe should be listed here, please don't hesitate to contact us. The list below is simply a list of the known alumni in our database.<% Sql="SELECT * FROM Players P, Cities C, Teams T WHERE P.collegeID = T.teamID and P.cityID = C.cityID and HS = '" & request.querystring("ID") & "' ORDER BY LastName,firstName" set rsObj2=rsconn.execute(sql) response.write "
| Player Name | " response.write "Position | " response.write "Born Date | " response.write "Place of Birth | " response.write "College | " response.write "Highest Level | " response.write "MLB Years | " response.write "|||
| " & rsObj2("lastName") & "," & rsObj2("firstName") & " | " else response.write "" & rsObj2("lastName") & "," & rsObj2("firstName") & " | " end if response.write "" & rsObj2("posit") & " | " response.write "" & rsObj2("bornDate") & " | " if rsObj2("cityName") <> "-" then response.write "" & rsObj2("cityName") & ", " & rsObj2("regionID") & " | " else response.write "" end if if rsObj2("CollegeID") <> 0 then response.write " | " & rsObj2("TeamName") & " | " else response.write "" end if response.write " | " & rsObj2("highLevel") & " | " response.write "" & rsObj2("mlbYears") & " | " response.write "
The following is a complete list of drafted players from this high school. Players in bold have reached the major leagues and those who are linked, have a player profile page here at The Baseball Cube. MLB Players in Bold<% Sql="SELECT * FROM Draft WHERE hsID = " & request.querystring("ID") & " ORDER BY year DESC,draftround,overall" set rsObj2=rsconn.execute(sql) response.write "
| Draft Year | " response.write "Round | " response.write "Overall | " response.write "Team | " response.write "Player Name | " response.write "Position | " response.write "College | " response.write "Highest Level | " response.write "MLB Years | " response.write "||||||||
| " & rsObj2("year") & " | " response.write "" & rsObj2("draftRound") & " | " response.write "" & rsObj2("overall") & " | " response.write "" & rsObj3("teamName") & " | " if isnull(rsObj2("PlayerID"))=false then Sql="SELECT * FROM Players P, Teams T WHERE P.collegeID = t.teamID and PlayerID = " & rsObj2("PlayerID") set rsObj3=rsConn.execute(Sql) if rsObj3.eof=false then if rsObj3("highLevel") <> "MLB" and isnull(rsObj3("highLevel"))=false then response.write "" & rsObj3("firstName") & " " & rsObj3("LastName") & " | " else if rsObj3("highLevel") = "MLB" then response.write "" & rsObj3("firstName") & " " & rsObj3("LastName") & " | " else response.write "" & rsObj3("firstName") & " " & rsObj3("LastName") & " | " end if end if else response.write "" & rsObj2("firstName") & " " & rsObj2("LastName") & " | " end if else response.write "" & rsObj2("firstName") & " " & rsObj2("LastName") & " | " end if response.write "" & lcase(rsObj2("posit")) & " | " if isnull(rsObj2("PlayerID"))=false then if rsObj3("CollegeID") <> 0 then response.write "" & rsObj3("TeamName") & " | " else response.write "" end if else response.write " | " end if if isnull(rsObj2("PlayerID"))=false then response.write " | " & rsObj3("highLevel") & " | " response.write "" & rsObj3("mlbYears") & " | " else response.write "" response.write " | " end if response.write " |