Line 322: int schoolid = GetID(shortname, Keys.School, 0);
Line 323: string[] fullname = name.Replace("/","").Split('_');
Line 324: string sqlstring = "SELECT TOP 1 player_id FROM tbl_Players LEFT JOIN tbl_Schools ON tbl_schools.school_id = tbl_Players.school_id WHERE tbl_Players.name LIKE '" + fullname[1].Replace("-", "''").Replace(",", ".") + "' AND firstname LIKE '" + fullname[0].Replace("-", "''").Replace(",", ".") + "' AND tbl_Players.school_id = '" + schoolid + "' AND tbl_players.status = '1' AND player_id IN (SELECT player_id FROM tbl_Roster LEFT JOIN tbl_Teams ON tbl_Teams.team_id = tbl_Roster.team_id WHERE school_id = '" + schoolid + "' AND sport_id = '" + sport + "' )";
Line 325:
Line 326: DataSet ds = ReturnDataSet(sqlstring, "Player");
|