Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
Set rs = Server.CreateObject("ADODB.Recordset") sql = "SELECT t.TeamsID, t.TeamName, t.Gender FROM Teams t INNER JOIN MeetTeams mt ON t.TeamsID = mt.TeamsID WHERE mt.MeetsID = " & lMeetID & " ORDER BY t.TeamName" rs.Open sql, conn2, 1, 2 MeetTeams = rs.GetRows() Set rs = Nothing
Join the community of 500,000 technology professionals and ask your questions.