<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include virtual="Connections/test.asp" -->
<!--#include virtual="scriptlets/functions.asp" -->
<%Session.LCID = 2057;%>

<!--SECTION TO ADD ARRAY FRM ENTRY SPREADSHEETS-->


<%
champsID=18
clubID=56

var competitors= new Array();// array to hold all the competitorID
var solos= new Array();
var ropes=new Array();
var teams=new Array();


//to list arrays copied from Spreadsheet
competitors[1]=new Array(0,'Meredith','Emily','1','F','21/10/2003');
competitors[2]=new Array(0,'Dickerson Weedy','Ellie','31329376','F','05/04/2002');
competitors[3]=new Array(0,'Dickerson Weedy.','Issy','1','F','15/03/2004');
competitors[4]=new Array(0,'Gordon','Lauren','31301826','F','09/08/2001');
competitors[5]=new Array(0,'Gordon.','Aimee','1','F','31/03/2004');
competitors[6]=new Array(0,'Stehenson','Emily','31365759','F','22/08/2003');
competitors[7]=new Array(0,'Turnbull','Bobbi','1','F','10/03/2004');
competitors[8]=new Array(0,'Christopher','Anya','1','F','18/06/2002');
competitors[9]=new Array(0,'Brown','Emily','1','F','09/11/2003');
competitors[10]=new Array(0,'Raine','Cerys','1','F','24/09/2004');
competitors[11]=new Array(0,'Bradley','Milly','31365652','F','03/12/2003');
competitors[12]=new Array(0,'Little','Jessica','31330160','F','08/06/2002');
competitors[13]=new Array(0,'King','Eleanor','1','F','08/03/2004');
competitors[14]=new Array(0,'Huntley','Joseph','31329688','M','24/03/2002');
competitors[15]=new Array(0,'Meeson','Jesse','31330161','M','19/04/2002');
competitors[16]=new Array(0,'Smith','Mitchell','1','M','02/10/2001');
competitors[17]=new Array(0,'Oakey','Luke','1','M','18/01/2004');
competitors[18]=new Array(0,'Guy','Matthew','1','M','10/03/2004');
competitors[19]=new Array(0,'Chandler','Cadie','1','F','16/01/1999');
competitors[20]=new Array(0,'Gilroy','Callum','31215651','M','16/09/1999');
competitors[21]=new Array(0,'Wells','James','31266221','M','19/01/2001');
competitors[22]=new Array(0,'Arkley','Daniel','1','M','12/03/1992');
competitors[23]=new Array(0,'Huntley','Carol','1','FB','05/01/1973');
competitors[24]=new Array(0,'Chandler','Joanne','1','FB','03/04/1973');
competitors[25]=new Array(0,'Taylor','Linda','1','FC','28/04/1966');
competitors[26]=new Array(0,'Meredith','John','1','MD','30/11/1951');
competitors[27]=new Array(0,'Chandler','Mark','1','MB','26/06/1970');
competitors[28]=new Array(0,'Todd','Trinity','1','F','16/08/2003');
competitors[29]=new Array(0,'Meeson','Alfie','31284161','M','14/03/2000');
competitors[30]=new Array(0,'Stannard Malloy','James','1','M','16/11/2001');
competitors[31]=new Array(0,'Wilshire','Katelyn','1','F','05/06/2005');
competitors[32]=new Array(0,'Hurst','Emily','11','F','17/07/2004');
competitors[33]=new Array(0,'Christopher','Lottie','1','F','27/12/2005');
competitors[34]=new Array(0,'Brimelow','Tanya','1','F','10/04/2006');
competitors[35]=new Array(0,'Graham','Lewis','1','M','27/07/2006');
competitors[36]=new Array(0,'Stephenson','Ben','1','M','25/09/2006');
competitors[37]=new Array(0,'Guy','Katie','1','F','06/07/2006');
competitors[38]=new Array(0,'Gilroy','Debbie','1','FC','02/11/1965');
competitors[39]=new Array(0,'TBC','TBC','1','M','01/01/1990');
competitors[40]=new Array(0,'Robbinson','Holly','1','F','01/01/2004');
competitors[41]=new Array(0,'McCallum','Mitch','1','M','02/01/2004');
competitors[42]=new Array(0,'Weightman','Daniel','1','M','03/01/2004');
competitors[43]=new Array(0,'Chandler.','Beth','1','F','04/01/2004');
competitors[44]=new Array(0,'Huntley','Matthew','1','M','05/01/2004');
solos[1]=new Array(1,13,'JG',27.43);
solos[2]=new Array(1,23,'JG',46.81);
solos[3]=new Array(1,15,'JG',42.41);
solos[4]=new Array(1,14,'JG',70);
solos[5]=new Array(2,13,'JG',20.7);
solos[6]=new Array(2,23,'JG',35.32);
solos[7]=new Array(2,15,'JG',32.2);
solos[8]=new Array(2,14,'JG',50);
solos[9]=new Array(3,13,'JG',32);
solos[10]=new Array(3,23,'JG',45);
solos[11]=new Array(3,15,'JG',50);
solos[12]=new Array(3,14,'JG',90);
solos[13]=new Array(4,13,'JG',19.8);
solos[14]=new Array(4,23,'JG',32.71);
solos[15]=new Array(4,15,'JG',30.5);
solos[16]=new Array(4,14,'JG',47);
solos[17]=new Array(5,13,'JG',32);
solos[18]=new Array(5,23,'JG',44);
solos[19]=new Array(5,15,'JG',58);
solos[20]=new Array(5,14,'JG',90);
solos[21]=new Array(6,13,'JG',25.9);
solos[22]=new Array(6,23,'JG',47.2);
solos[23]=new Array(6,15,'JG',43.23);
solos[24]=new Array(6,14,'JG',90);
solos[25]=new Array(7,13,'JG',40);
solos[26]=new Array(7,23,'JG',50);
solos[27]=new Array(7,15,'JG',60);
solos[28]=new Array(7,14,'JG',120);
solos[29]=new Array(8,13,'JG',22.5);
solos[30]=new Array(8,23,'JG',39.14);
solos[31]=new Array(8,15,'JG',36.17);
solos[32]=new Array(8,14,'JG',55);
solos[33]=new Array(9,13,'JG',33);
solos[34]=new Array(9,23,'JG',56.02);
solos[35]=new Array(9,15,'JG',56.69);
solos[36]=new Array(9,14,'JG',120);
solos[37]=new Array(10,33,'RG11',23.32);
solos[38]=new Array(10,13,'RG11',30.84);
solos[39]=new Array(10,34,'RG11',29.94);
solos[40]=new Array(10,35,'RG11',16.67);
solos[41]=new Array(11,13,'JG',22.52);
solos[42]=new Array(11,23,'JG',37.67);
solos[43]=new Array(11,15,'JG',40.19);
solos[44]=new Array(11,14,'JG',90);
solos[45]=new Array(12,13,'JG',20.53);
solos[46]=new Array(12,23,'JG',35.7);
solos[47]=new Array(12,15,'JG',35.61);
solos[48]=new Array(12,14,'JG',75);
solos[49]=new Array(13,13,'JG',26);
solos[50]=new Array(13,23,'JG',44);
solos[51]=new Array(13,15,'JG',50);
solos[52]=new Array(13,14,'JG',85);
solos[53]=new Array(14,13,'JB',19.78);
solos[54]=new Array(14,23,'JB',32.53);
solos[55]=new Array(14,15,'JB',33.14);
solos[56]=new Array(14,14,'JB',47);
solos[57]=new Array(15,13,'JB',20);
solos[58]=new Array(15,23,'JB',35);
solos[59]=new Array(15,15,'JB',32);
solos[60]=new Array(15,14,'JB',50);
solos[61]=new Array(16,13,'JB',22.65);
solos[62]=new Array(16,23,'JB',40.19);
solos[63]=new Array(16,15,'JB',38.17);
solos[64]=new Array(16,14,'JB',60);
solos[65]=new Array(17,13,'JB',30);
solos[66]=new Array(17,23,'JB',54);
solos[67]=new Array(17,15,'JB',60);
solos[68]=new Array(17,14,'JB',90);
solos[69]=new Array(18,13,'JB',28);
solos[70]=new Array(18,23,'JB',40);
solos[71]=new Array(18,15,'JB',52);
solos[72]=new Array(18,14,'JB',75);
solos[73]=new Array(19,13,'SG',22.4);
solos[74]=new Array(19,23,'SG',34.71);
solos[75]=new Array(19,15,'SG',29.58);
solos[76]=new Array(19,16,'SG',37.09);
solos[77]=new Array(20,13,'SB',20.18);
solos[78]=new Array(20,23,'SB',32.87);
solos[79]=new Array(20,15,'SB',28.82);
solos[80]=new Array(20,16,'SB',34.17);
solos[81]=new Array(21,13,'SB',19.41);
solos[82]=new Array(21,23,'SB',32.85);
solos[83]=new Array(21,15,'SB',30.59);
solos[84]=new Array(21,16,'SB',31.92);
solos[85]=new Array(22,13,'M',45);
solos[86]=new Array(22,23,'M',50.8);
solos[87]=new Array(22,15,'M',59);
solos[88]=new Array(22,16,'M',45);
solos[89]=new Array(23,13,'MaF',60);
solos[90]=new Array(23,23,'MaF',80);
solos[91]=new Array(23,15,'MaF',60);
solos[92]=new Array(23,16,'MaF',65);
solos[93]=new Array(24,13,'MaF',60);
solos[94]=new Array(24,23,'MaF',80);
solos[95]=new Array(24,15,'MaF',60);
solos[96]=new Array(24,16,'MaF',65);
solos[97]=new Array(25,15,'MaF',60);
solos[98]=new Array(25,16,'MaF',60);
solos[99]=new Array(26,13,'MaM',36.28);
solos[100]=new Array(26,23,'MaM',56.58);
solos[101]=new Array(26,15,'MaM',50.87);
solos[102]=new Array(26,16,'MaM',45);
solos[103]=new Array(27,13,'MaM',37.89);
solos[104]=new Array(27,23,'MaM',51.92);
solos[105]=new Array(27,15,'MaM',41.95);
solos[106]=new Array(27,16,'MaM',39.62);
solos[107]=new Array(28,13,'JG',22.49);
solos[108]=new Array(28,23,'JG',37.24);
solos[109]=new Array(28,15,'JG',38);
solos[110]=new Array(28,14,'JG',55);
solos[111]=new Array(29,13,'SB',20);
solos[112]=new Array(29,23,'SB',35);
solos[113]=new Array(29,15,'SB',34);
solos[114]=new Array(29,16,'SB',33);
solos[115]=new Array(30,13,'JB',30);
solos[116]=new Array(30,23,'JB',40);
solos[117]=new Array(30,15,'JB',45);
solos[118]=new Array(30,14,'JB',60);
solos[119]=new Array(31,33,'RG11',24);
solos[120]=new Array(31,13,'RG11',33);
solos[121]=new Array(31,34,'RG11',24);
solos[122]=new Array(31,35,'RG11',18);
solos[123]=new Array(32,33,'RG11',20);
solos[124]=new Array(32,13,'RG11',22);
solos[125]=new Array(32,34,'RG11',24);
solos[126]=new Array(32,35,'RG11',15.54);
solos[127]=new Array(33,33,'RG11',24.81);
solos[128]=new Array(33,13,'RG11',33);
solos[129]=new Array(33,34,'RG11',24.78);
solos[130]=new Array(33,35,'RG11',18.39);
solos[131]=new Array(34,33,'RG11',28);
solos[132]=new Array(34,13,'RG11',35);
solos[133]=new Array(34,34,'RG11',25);
solos[134]=new Array(34,35,'RG11',22);
solos[135]=new Array(35,33,'RB9',27.11);
solos[136]=new Array(35,13,'RB9',60);
solos[137]=new Array(35,34,'RB9',42.67);
solos[138]=new Array(35,35,'RB9',19.37);
solos[139]=new Array(36,33,'RB9',30);
solos[140]=new Array(36,13,'RB9',60);
solos[141]=new Array(36,34,'RB9',50);
solos[142]=new Array(36,35,'RB9',30);
solos[143]=new Array(37,33,'RG9',24.39);
solos[144]=new Array(37,13,'RG9',30.8);
solos[145]=new Array(37,34,'RG9',20.78);
solos[146]=new Array(37,35,'RG9',17.67);
solos[147]=new Array(38,13,'MaF',60);
solos[148]=new Array(38,23,'MaF',70);
solos[149]=new Array(38,15,'MaF',60);
solos[150]=new Array(38,16,'MaF',60);
solos[151]=new Array(40,13,'JG',0);
solos[152]=new Array(40,23,'JG',0);
solos[153]=new Array(40,15,'JG',0);
solos[154]=new Array(40,14,'JG',0);
solos[155]=new Array(41,13,'M',15);
solos[156]=new Array(41,23,'M',25);
solos[157]=new Array(41,15,'M',28);
solos[158]=new Array(41,16,'M',29);
solos[159]=new Array(42,13,'M',18);
solos[160]=new Array(42,23,'M',28);
solos[161]=new Array(42,15,'M',30);
solos[162]=new Array(42,16,'M',32);
solos[163]=new Array(43,13,'SG',22.4);
solos[164]=new Array(43,23,'SG',34.71);
solos[165]=new Array(43,15,'SG',29.58);
solos[166]=new Array(43,16,'SG',37.09);
solos[167]=new Array(44,33,'RB9',0);
solos[168]=new Array(44,13,'RB9',0);
teams[1]=new Array('A',1,4,28,8,19,'JG',66.41);
teams[2]=new Array('A',1,4,28,8,20,'JG',61.41);
teams[3]=new Array('A',1,4,28,8,18,'JG',49.37);
teams[4]=new Array('B',12,1,7,9,19,'JG',75.06);
teams[5]=new Array('B',12,1,7,9,20,'JG',70.7);
teams[6]=new Array('B',12,1,7,9,18,'JG',61);
teams[7]=new Array('C',11,13,5,3,19,'JG',90.93);
teams[8]=new Array('C',11,13,5,3,20,'JG',83.95);
teams[9]=new Array('C',11,13,5,3,18,'JG',72.36);
teams[10]=new Array('D',36,40,39,39,19,'JG',100);
teams[11]=new Array('D',36,40,39,39,20,'JG',100);
teams[12]=new Array('D',36,40,39,39,18,'JG',90);
teams[13]=new Array('A',14,15,17,18,19,'JB',68.18);
teams[14]=new Array('A',14,15,17,18,20,'JB',64.79);
teams[15]=new Array('A',14,15,17,18,18,'JB',55.44);
teams[16]=new Array('B',30,16,39,39,19,'JB',100);
teams[17]=new Array('B',30,16,39,39,20,'JB',90);
teams[18]=new Array('B',30,16,39,39,18,'JB',80);
teams[19]=new Array('',19,29,21,20,19,'SB',60.01);
teams[20]=new Array('',19,29,21,20,20,'SB',52.65);
teams[21]=new Array('',19,29,21,20,18,'SB',42);
teams[22]=new Array('A',39,39,39,39,19,'M',82.53);
teams[23]=new Array('A',39,39,39,39,20,'M',100);
teams[24]=new Array('A',39,39,39,39,18,'M',95);
teams[25]=new Array('',38,23,19,23,19,'MaF',98.7);
teams[26]=new Array('',38,23,19,23,20,'MaF',92.62);
teams[27]=new Array('',38,23,19,23,18,'MaF',105);
teams[28]=new Array('',18,36,35,44,37,'RB9',100);
teams[29]=new Array('',18,36,35,44,36,'RB9',150);
teams[30]=new Array('',32,10,31,34,37,'RB11',75);
teams[31]=new Array('',32,10,31,34,36,'RB11',115.8);
teams[32]=new Array('',33,39,39,39,37,'RB11',90);
teams[33]=new Array('',33,39,39,39,36,'RB11',150);
teams[34]=new Array('B',39,39,39,39,19,'M',0);
teams[35]=new Array('B',39,39,39,39,20,'M',0);
teams[36]=new Array('B',39,39,39,39,18,'M',0);
teams[37]=new Array('',39,39,39,39,19,'SG',0);
teams[38]=new Array('',39,39,39,39,20,'SG',0);
teams[39]=new Array('',39,39,39,39,18,'SG',0);


%>

<!--adds TeamMembers to System-->
<%


  for (var i=1;i<competitors.length;i++){
	  var addCompetitor=Server.CreateObject('ADODB.Command');
  addCompetitor.ActiveConnection=BULSCA_CON_STRING;
	addCompetitor.CommandText ="INSERT INTO CHAMPS_Competitors(RLSS_NUMBER,First_Name,Last_Name,DOB,Club_ID,CHAMPS_ID,Type,last_amended,amended_by,time_added,added_by) VALUES ("+String(competitors[i][3])+",'"+SQLinjectionStop(String(competitors[i][2]))+"','"+SQLinjectionStop(String(competitors[i][1]))+"','"+String(competitors[i][5])+" 00:00',"+clubID+","+champsID+",'"+String(competitors[i][4])+"',Date(),'"+String(Session("Username"))+"',Date(),'"+String(Session("Username"))+"')" ;
	addCompetitor.Execute();
	addCompetitor.ActiveConnection.Close();
	
	
	//adds competitors on-line ID to the array
	
  var getID = Server.CreateObject("ADODB.Recordset");
	getID.ActiveConnection = BULSCA_CON_STRING;
	getID.Source = "SELECT `competitor_ID` FROM  CHAMPS_Competitors  WHERE `RLSS_NUMBER` = "+competitors[i][3]+" AND `CHAMPS_ID` ="+champsID+" AND `CLUB_ID` ="+clubID+" ORDER BY competitor_ID DESC";
	getID.CursorType = 0;
	getID.CursorLocation = 2;
	getID.LockType = 1;
	getID.Open();
	competitors[i][0]=getID.Fields.Item("competitor_ID").Value;
	getID.Close();
		
  }

%>
Complete


<!--adds Solo Races to System-->
<%
for (var i=1;i<solos.length;i++){

// for the new team must create the master record first before puttign the swim tow time in
  var addEntry=Server.CreateObject('ADODB.Command');
  addEntry.ActiveConnection=BULSCA_CON_STRING;
  addEntry .CommandText ="INSERT INTO CHAMPS_SPEED_ENTRIES  (`EVENT_ID`,`SEX`, `CHAMPS_ID`, `Club_ID`,`time_added`,`added_by` ) VALUES  ("+solos[i][1]+",'"+solos[i][2]+"',"+String(champsID)+","+String(clubID)+",Date(),'"+String(Session("Username"))+"')";
  addEntry.Execute();
  addEntry.ActiveConnection.Close();
  var getID = Server.CreateObject("ADODB.Recordset");
	getID.ActiveConnection = BULSCA_CON_STRING;
	getID.Source = "SELECT `ENTRY_ID` FROM  CHAMPS_SPEED_ENTRIES  WHERE `EVENT_ID` = "+solos[i][1]+" AND `CHAMPS_ID` ="+champsID+" AND `CLUB_ID` ="+clubID+" ORDER BY ENTRY_ID DESC";
	getID.CursorType = 0;
	getID.CursorLocation = 2;
	getID.LockType = 1;
	getID.Open();
	entryID=getID.Fields.Item("ENTRY_ID").Value;
	getID.Close();

var teamDetails = Server.CreateObject('ADODB.Command');
  teamDetails .ActiveConnection = BULSCA_CON_STRING;
  var entryTime=solos[i][3]
  teamDetails .CommandText ="insert into CHAMPS_ENTRIES_DETAILS_1(`ENTRY_ID`,`Type`, `Competitor_ID_1`, `ENTRY_TIME`, `time_added`,`added_by`) values ("+entryID+",'S',"+competitors[solos[i][0]][0]+","+entryTime+",Date(),'"+String(Session("Username"))+"')" ;
  teamDetails .Execute();
  teamDetails .ActiveConnection.Close(); 
  }
  

  %>
  
  
<!--adds Rope Races to System-->
<%for (var i=1;i<ropes.length;i++){

var addEntry=Server.CreateObject('ADODB.Command');
  addEntry.ActiveConnection=BULSCA_CON_STRING;
  addEntry .CommandText ="INSERT INTO CHAMPS_SPEED_ENTRIES  (`EVENT_ID`,`SEX`, `CHAMPS_ID`, `Club_ID`,`time_added`,`added_by` ) VALUES  ("+ropes[i][2]+",'"+ropes[i][3]+"',"+String(champsID)+","+String(clubID)+",Date(),'"+String(Session("Username"))+"')";
  addEntry.Execute();
  addEntry.ActiveConnection.Close();
  var getID = Server.CreateObject("ADODB.Recordset");
	getID.ActiveConnection = BULSCA_CON_STRING;
	getID.Source = "SELECT `ENTRY_ID` FROM  CHAMPS_SPEED_ENTRIES  WHERE `EVENT_ID` = "+ropes[i][2]+" AND `CHAMPS_ID` ="+champsID+" AND `CLUB_ID` ="+clubID+" ORDER BY ENTRY_ID DESC";
	getID.CursorType = 0;
	getID.CursorLocation = 2;
	getID.LockType = 1;
	getID.Open();
	entryID=getID.Fields.Item("ENTRY_ID").Value;
	getID.Close();

var teamDetails = Server.CreateObject('ADODB.Command');
  teamDetails .ActiveConnection = BULSCA_CON_STRING;
  var entryTime=ropes[i][4]
  teamDetails .CommandText ="insert into CHAMPS_ENTRIES_DETAILS_2(`ENTRY_ID`,`Type`, `Competitor_ID_1`, `Competitor_ID_2`, `ENTRY_TIME`, `time_added`,`added_by`) values ("+entryID+",'S',"+competitors[ropes[i][0]][0]+","+competitors[ropes[i][1]][0]+","+entryTime+",Date(),'"+String(Session("Username"))+"')" ;
  teamDetails .Execute();
  teamDetails .ActiveConnection.Close();
}
%>


<!--adds Team Races to System-->
<%for (var i=1;i<teams.length;i++){


  var addEntry=Server.CreateObject('ADODB.Command');
  addEntry.ActiveConnection=BULSCA_CON_STRING;
  addEntry .CommandText ="INSERT INTO CHAMPS_SPEED_ENTRIES  (`EVENT_ID`,`SEX`, `CHAMPS_ID`, `Club_ID`,`time_added`,`added_by` ) VALUES  ("+teams[i][5]+",'"+String(teams[i][6])+"',"+String(champsID)+","+String(clubID)+",Date(),'"+String(Session("Username"))+"')";
  addEntry.Execute();
  addEntry.ActiveConnection.Close();
  var getID = Server.CreateObject("ADODB.Recordset");
	getID.ActiveConnection = BULSCA_CON_STRING;
	getID.Source = "SELECT `ENTRY_ID` FROM  CHAMPS_SPEED_ENTRIES  WHERE `EVENT_ID` = "+teams[i][5]+" AND `CHAMPS_ID` ="+champsID+" AND `CLUB_ID` ="+clubID+" ORDER BY ENTRY_ID DESC";
	getID.CursorType = 0;
	getID.CursorLocation = 2;
	getID.LockType = 1;
	getID.Open();
	entryID=getID.Fields.Item("ENTRY_ID").Value;
	getID.Close();

var teamDetails = Server.CreateObject('ADODB.Command');
  teamDetails .ActiveConnection = BULSCA_CON_STRING;
  var entryTime=teams[i][7]
  teamDetails .CommandText ="insert into CHAMPS_ENTRIES_DETAILS_4(`ENTRY_ID`,`Type`, `Competitor_ID_1`, `Competitor_ID_2`, `Competitor_ID_3`, `Competitor_ID_4`, `ENTRY_TIME`, `time_added`,`added_by`) values ("+entryID+",'S',"+competitors[teams[i][1]][0]+","+competitors[teams[i][2]][0]+","+competitors[teams[i][3]][0]+","+competitors[teams[i][4]][0]+","+entryTime+",Date(),'"+String(Session("Username"))+"')" ;
  teamDetails .Execute();
  teamDetails .ActiveConnection.Close();

if(teams[i][0]!=0){
//code to submitt team name if one providded to optimise space as not saving it when not required.

var teamName = Server.CreateObject('ADODB.Command');
  teamName .ActiveConnection = BULSCA_CON_STRING;
  teamName .CommandText ="INSERT INTO CHAMPS_TEAMNAMES ( Entry_ID_4, Description ) SELECT CHAMPS_ENTRIES_DETAILS_4.ENTRIES_DETAILS_4_ID,' "+teams[i][0]+"' AS Expr1 FROM CHAMPS_ENTRIES_DETAILS_4 WHERE (((CHAMPS_ENTRIES_DETAILS_4.ENTRIES_DETAILS_4_ID)=(SELECT Max(CHAMPS_ENTRIES_DETAILS_4.ENTRIES_DETAILS_4_ID) AS MaxOfENTRIES_DETAILS_4_ID FROM  CHAMPS_ENTRIES_DETAILS_4 GROUP BY CHAMPS_ENTRIES_DETAILS_4.ENTRY_ID HAVING (((CHAMPS_ENTRIES_DETAILS_4.ENTRY_ID)="+entryID+")))));";
  teamName .Execute();
  teamName .ActiveConnection.Close();
}

}%>