INSERT INTO dbo.LaxIndividualRec (PerGender, FirstName, LastName, Gradyear, RecYear, Assists, Goals, Tpoints, TpointsAllY, "Position", Awards, JerseyNumber, PlayerEmail)
VALUES (
''
,
''
,
''
,
''
,
''
,
NULL
,
NULL
,
NULL
,
NULL
,
''
,
''
,
NULL
,
''
)
UPDATE dbo.LaxIndividualRec
SET PerGender=
''
, FirstName=
''
, LastName=
''
, Gradyear=
''
, RecYear=
''
, Assists=
NULL
, Goals=
NULL
, Tpoints=
NULL
, TpointsAllY=
NULL
, "Position"=
''
, Awards=
''
, JerseyNumber=
NULL
, PlayerEmail=
''
WHERE ID=
UPDATE dbo.FamilyLax
SET LName=
''
, field1=
''
, TotalPoints=
NULL
WHERE ID=
INSERT INTO dbo.FamilyLax (LName, field1, TotalPoints)
VALUES (
''
,
''
,
NULL
)
SELECT *
FROM dbo.LaxSeasons
WHERE LaxYear =
ORDER BY LaxYear ASC
SELECT LaxYear
FROM dbo.LaxSeasons
ORDER BY LaxYear ASC
SELECT *
FROM dbo.LaxIndividualRec
WHERE RecYear =
ORDER BY Tpoints DESC
SELECT *
FROM dbo.LaxGameCloseUp
WHERE LaxYear =
SELECT *
FROM dbo.LaxGameCloseUp
WHERE LaxYear =
ORDER BY GameDay ASC
rsPointScorers_NumRows = rsPointScorers.RecordCount;
MM_paramName = "";
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
// create the list of parameters which should not be maintained
MM_removeList = "&index=";
If (MM_paramName NEQ "") MM_removeList = MM_removeList & "&" & MM_paramName & "=";
MM_keepURL=""; MM_keepForm=""; MM_keepBoth=""; MM_keepNone="";
// add the existing URL parameters to the MM_keepURL string
MM_params=ListToArray(CGI.QUERY_STRING,"&");
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (FindNoCase("&" & GetToken(MM_params[i],1,"=") & "=",MM_removeList) Is 0)
MM_keepURL = MM_keepURL & "&" & MM_params[i];
}
// add the existing Form variables to the MM_keepForm string
If (IsDefined("FORM.FieldNames")) {
MM_params=ListToArray(FORM.FieldNames,",");
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (FindNoCase("&" & MM_params[i] & "=",MM_removeList) Is 0)
MM_keepForm = MM_keepForm & "&" & LCase(MM_params[i]) & "=" & URLEncodedFormat(Evaluate("FORM." & MM_params[i]));
}
}
// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm;
If (MM_keepURL NEQ "") MM_keepURL = RemoveChars(MM_keepURL,1,1);
If (MM_keepForm NEQ "") MM_keepForm = RemoveChars(MM_keepForm,1,1);
If (MM_keepBoth NEQ "") MM_keepBoth = RemoveChars(MM_keepBoth,1,1);
INSERT INTO dbo.LaxSeasons (TeamPic, LaxYear, BoysVarGC, TeamAwards, Gwon, GLost, Gtied, GoalsGC, GoalsOpp, AddNotes)
VALUES (
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
)
UPDATE dbo.LaxSeasons
SET TeamPic=
''
, LaxYear=
''
, BoysVarGC=
''
, TeamAwards=
''
, Gwon=
''
, GLost=
''
, Gtied=
''
, InfoGen=
''
, GoalsGC=
''
, GoalsOpp=
''
, AddNotes=
''
, HCoach=
''
, ACoach=
''
, TeamPlace=
''
, MVPlayer=
''
, PlayerAwards=
''
, LeagueRec=
''
WHERE ID=
INSERT INTO dbo.LaxGameCloseUp (LaxYear, GameDay, HorA, OppTeam, WorLoss, GCFirst, OppFirst, GCSecond, OppSecond, GCThird, OppThird, GCFourth, OppFourth, GCFScore, OppFScore, GCScorers, GCAssists, additional1)
VALUES (
''
,
NULL
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
,
''
)
UPDATE dbo.LaxGameCloseUp
SET LaxYear=
''
, GameDay=
NULL
, HorA=
''
, OppTeam=
''
, WorLoss=
''
, GCFirst=
''
, OppFirst=
''
, GCSecond=
''
, OppSecond=
''
, GCThird=
''
, OppThird=
''
, GCFourth=
''
, OppFourth=
''
, GCFScore=
''
, OppFScore=
''
, GCScorers=
''
, GCAssists=
''
WHERE ID=
SELECT *
FROM dbo.LaxSeasons
ORDER BY LaxYear Desc
SELECT LaxYear
FROM dbo.LaxSeasons
ORDER BY LaxYear desc
Repeat1_NumRows = 10;
rsGCGamesHistory_NumRows = rsGCGamesHistory_NumRows + Repeat1_NumRows;
// *** Recordset Stats, Move To Record, and Go To Record: set stats variables
// set the record count
rsGCGamesHistory_total = rsGCGamesHistory.RecordCount;
// set the number of rows displayed on this page
If (rsGCGamesHistory_NumRows LT 0 OR rsGCGamesHistory_NumRows GTE rsGCGamesHistory_total) {
rsGCGamesHistory_NumRows = rsGCGamesHistory_total;
} Else If (rsGCGamesHistory_NumRows EQ 0) {
rsGCGamesHistory_NumRows = 1;
}
// set the first and last displayed record
rsGCGamesHistory_first = Min(1, rsGCGamesHistory_total);
rsGCGamesHistory_last = Min(rsGCGamesHistory_NumRows, rsGCGamesHistory_total);
MM_paramName = "";
// *** Move To Record and Go To Record: declare variables
MM_rs = rsGCGamesHistory;
MM_rsCount = rsGCGamesHistory_total;
MM_size = rsGCGamesHistory_NumRows;
MM_uniqueCol = "";
MM_paramName = "";
MM_offset = 1;
MM_atTotal = false;
MM_paramIsDefined = false;
If (MM_paramName NEQ "") MM_paramIsDefined = IsDefined(MM_paramName);
// *** Move To Record: handle 'index' or 'offset' parameter
If (NOT MM_paramIsDefined AND MM_rsCount NEQ 0) {
// use index parameter if defined, otherwise use offset parameter
If (IsDefined("index")) {
MM_offset = index;
} Else If (IsDefined("offset")) {
MM_offset = offset;
}
// check if we are past the end of the recordset
If (MM_offset GT MM_rsCount OR MM_offset EQ 0) { // past end or move last
If ((MM_rsCount MOD MM_size) NEQ 0) { // last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount MOD MM_size) + 1;
} Else {
MM_offset = MM_rsCount - MM_size + 1;
}
}
}
// *** Move To Record: replace the current query, for navigation on a detail page
If (MM_size EQ 1) { // if no repeated regions are defined
// create a new query with one row
MM_newQuery = QueryNew(MM_rs.ColumnList);
QueryAddRow(MM_newQuery, 1);
// copy the data in the row pointed to by MM_offset to the new query
MM_columns = ListToArray(MM_rs.ColumnList,",");
For (i=1; i LTE ArrayLen(MM_columns); i=i+1) {
QuerySetCell(MM_newQuery, MM_columns[i], MM_rs[MM_columns[i]][MM_offset], 1);
}
// change the recordset to be only this one row
rsGCGamesHistory = MM_newQuery;
}
// *** Move To Record: update recordset stats
// set the first and last displayed record
rsGCGamesHistory_first = Min(MM_offset, MM_rsCount);
rsGCGamesHistory_last = Min(MM_offset + MM_size - 1, MM_rsCount);
// set the starting index for repeated regions on this recordset
rsGCGamesHistory_Index = MM_offset;
// set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_offset + MM_size - 1 GTE MM_rsCount);
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
// create the list of parameters which should not be maintained
MM_removeList = "&index=";
If (MM_paramName NEQ "") MM_removeList = MM_removeList & "&" & MM_paramName & "=";
MM_keepURL=""; MM_keepForm=""; MM_keepBoth=""; MM_keepNone="";
// add the existing URL parameters to the MM_keepURL string
MM_params=ListToArray(CGI.QUERY_STRING,"&");
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (FindNoCase("&" & GetToken(MM_params[i],1,"=") & "=",MM_removeList) Is 0)
MM_keepURL = MM_keepURL & "&" & MM_params[i];
}
// add the existing Form variables to the MM_keepForm string
If (IsDefined("FORM.FieldNames")) {
MM_params=ListToArray(FORM.FieldNames,",");
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (FindNoCase("&" & MM_params[i] & "=",MM_removeList) Is 0)
MM_keepForm = MM_keepForm & "&" & LCase(MM_params[i]) & "=" & URLEncodedFormat(Evaluate("FORM." & MM_params[i]));
}
}
// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm;
If (MM_keepURL NEQ "") MM_keepURL = RemoveChars(MM_keepURL,1,1);
If (MM_keepForm NEQ "") MM_keepForm = RemoveChars(MM_keepForm,1,1);
If (MM_keepBoth NEQ "") MM_keepBoth = RemoveChars(MM_keepBoth,1,1);
// *** Move To Record: set the strings for the first, last, next, and previous links
MM_keepMove = MM_keepBoth;
MM_moveParam = "index";
// if the page has a repeated region, remove 'offset' from the maintained parameters
if (MM_size GT 1) {
MM_moveParam = "offset";
MM_params = ListToArray(MM_keepMove,"&");
MM_keepMove = "";
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (CompareNoCase(GetToken(MM_params[i],1,"="),MM_moveParam) IS NOT 0) {
MM_keepMove = MM_keepMove & "&" & MM_params[i];
}
}
If (MM_keepMove NEQ "") {
MM_keepMove = RemoveChars(MM_keepMove,1,1);
}
}
// set the strings for the move to links
if (MM_keepMove NEQ "") MM_keepMove = MM_keepMove & "&";
urlStr = CGI.SCRIPT_NAME & "?" & MM_keepMove & MM_moveParam & "=";
MM_moveFirst = urlStr & "1";
MM_moveLast = urlStr & "0";
MM_moveNext = urlStr & (MM_offset + MM_size);
MM_movePrev = urlStr & Max(MM_offset-MM_size,1);
SELECT *
FROM dbo.FamilyLax
ORDER BY TotalPoints DESC
Repeat1_NumRows = 20;
rsFamily_NumRows = rsFamily_NumRows + Repeat1_NumRows;
// *** Recordset Stats, Move To Record, and Go To Record: set stats variables
// set the record count
rsFamily_total = rsFamily.RecordCount;
// set the number of rows displayed on this page
If (rsFamily_NumRows LT 0 OR rsFamily_NumRows GTE rsFamily_total) {
rsFamily_NumRows = rsFamily_total;
} Else If (rsFamily_NumRows EQ 0) {
rsFamily_NumRows = 1;
}
// set the first and last displayed record
rsFamily_first = Min(1, rsFamily_total);
rsFamily_last = Min(rsFamily_NumRows, rsFamily_total);
MM_paramName = "";
// *** Move To Record and Go To Record: declare variables
MM_rs = rsFamily;
MM_rsCount = rsFamily_total;
MM_size = rsFamily_NumRows;
MM_uniqueCol = "";
MM_paramName = "";
MM_offset = 1;
MM_atTotal = false;
MM_paramIsDefined = false;
If (MM_paramName NEQ "") MM_paramIsDefined = IsDefined(MM_paramName);
// *** Move To Record: handle 'index' or 'offset' parameter
If (NOT MM_paramIsDefined AND MM_rsCount NEQ 0) {
// use index parameter if defined, otherwise use offset parameter
If (IsDefined("index")) {
MM_offset = index;
} Else If (IsDefined("offset")) {
MM_offset = offset;
}
// check if we are past the end of the recordset
If (MM_offset GT MM_rsCount OR MM_offset EQ 0) { // past end or move last
If ((MM_rsCount MOD MM_size) NEQ 0) { // last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount MOD MM_size) + 1;
} Else {
MM_offset = MM_rsCount - MM_size + 1;
}
}
}
// *** Move To Record: replace the current query, for navigation on a detail page
If (MM_size EQ 1) { // if no repeated regions are defined
// create a new query with one row
MM_newQuery = QueryNew(MM_rs.ColumnList);
QueryAddRow(MM_newQuery, 1);
// copy the data in the row pointed to by MM_offset to the new query
MM_columns = ListToArray(MM_rs.ColumnList,",");
For (i=1; i LTE ArrayLen(MM_columns); i=i+1) {
QuerySetCell(MM_newQuery, MM_columns[i], MM_rs[MM_columns[i]][MM_offset], 1);
}
// change the recordset to be only this one row
rsFamily = MM_newQuery;
}
// *** Move To Record: update recordset stats
// set the first and last displayed record
rsFamily_first = Min(MM_offset, MM_rsCount);
rsFamily_last = Min(MM_offset + MM_size - 1, MM_rsCount);
// set the starting index for repeated regions on this recordset
rsFamily_Index = MM_offset;
// set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_offset + MM_size - 1 GTE MM_rsCount);
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
// create the list of parameters which should not be maintained
MM_removeList = "&index=";
If (MM_paramName NEQ "") MM_removeList = MM_removeList & "&" & MM_paramName & "=";
MM_keepURL=""; MM_keepForm=""; MM_keepBoth=""; MM_keepNone="";
// add the existing URL parameters to the MM_keepURL string
MM_params=ListToArray(CGI.QUERY_STRING,"&");
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (FindNoCase("&" & GetToken(MM_params[i],1,"=") & "=",MM_removeList) Is 0)
MM_keepURL = MM_keepURL & "&" & MM_params[i];
}
// add the existing Form variables to the MM_keepForm string
If (IsDefined("FORM.FieldNames")) {
MM_params=ListToArray(FORM.FieldNames,",");
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (FindNoCase("&" & MM_params[i] & "=",MM_removeList) Is 0)
MM_keepForm = MM_keepForm & "&" & LCase(MM_params[i]) & "=" & URLEncodedFormat(Evaluate("FORM." & MM_params[i]));
}
}
// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm;
If (MM_keepURL NEQ "") MM_keepURL = RemoveChars(MM_keepURL,1,1);
If (MM_keepForm NEQ "") MM_keepForm = RemoveChars(MM_keepForm,1,1);
If (MM_keepBoth NEQ "") MM_keepBoth = RemoveChars(MM_keepBoth,1,1);
// *** Move To Record: set the strings for the first, last, next, and previous links
MM_keepMove = MM_keepBoth;
MM_moveParam = "index";
// if the page has a repeated region, remove 'offset' from the maintained parameters
if (MM_size GT 1) {
MM_moveParam = "offset";
MM_params = ListToArray(MM_keepMove,"&");
MM_keepMove = "";
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (CompareNoCase(GetToken(MM_params[i],1,"="),MM_moveParam) IS NOT 0) {
MM_keepMove = MM_keepMove & "&" & MM_params[i];
}
}
If (MM_keepMove NEQ "") {
MM_keepMove = RemoveChars(MM_keepMove,1,1);
}
}
// set the strings for the move to links
if (MM_keepMove NEQ "") MM_keepMove = MM_keepMove & "&";
urlStr = CGI.SCRIPT_NAME & "?" & MM_keepMove & MM_moveParam & "=";
MM_moveFirst = urlStr & "1";
MM_moveLast = urlStr & "0";
MM_moveNext = urlStr & (MM_offset + MM_size);
MM_movePrev = urlStr & Max(MM_offset-MM_size,1);
Garden City Lacrosse
#DateFormat(Now(), "DDD, MMM DD, YYYY")#
Here is a listing of Teams and their records. It starts at the present day and goes all the way back to 1935. Go back ten years at a time with the navigational buttons at the bottom of the page. It is a work in progress so come back to view the History as it is updated. To see more information about a particular team select the team year or picture.
Records
#rsGCGamesHistory_first# to #rsGCGamesHistory_last# of #rsGCGamesHistory_total# years of Lacrosse History |">">">">
Back 
