<%@LANGUAGE="JAVASCRIPT"%> <% // *** Edit Operations: declare variables // set the form action variable var MM_editAction = Request.ServerVariables("SCRIPT_NAME"); if (Request.QueryString) { MM_editAction += "?" + Request.QueryString; } // boolean to abort record edit var MM_abortEdit = false; // query string to execute var MM_editQuery = ""; %> <% // *** Insert Record: set variables if (String(Request("MM_insert")) == "register") { var MM_editConnection = MM_troop9_STRING; var MM_editTable = "register"; var MM_editRedirectUrl = "confirmation.asp"; var MM_fieldsStr = "FirstName|value|LastName|value|email|value|phone|value|VeteransFirstName|value|VeteransLastName|value|vetfullname|value|Rank|value|status|value|branch|value|activities|value|information|value"; var MM_columnsStr = "FirstName|',none,''|LastName|',none,''|email|',none,''|Phone|',none,''|VeteransFirstName|',none,''|VeteransLastName|',none,''|vetfullname|',none,''|Rank|',none,''|Status|',none,''|Branch|',none,''|activities|',none,''|information|',none,''"; // create the MM_fields and MM_columns arrays var MM_fields = MM_fieldsStr.split("|"); var MM_columns = MM_columnsStr.split("|"); // set the form values for (var i=0; i+1 < MM_fields.length; i+=2) { MM_fields[i+1] = String(Request.Form(MM_fields[i])); } // append the query string to the redirect URL if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) { MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString; } } %> <% // *** Insert Record: construct a sql insert statement and execute it if (String(Request("MM_insert")) != "undefined") { // create the sql insert statement var MM_tableValues = "", MM_dbValues = ""; for (var i=0; i+1 < MM_fields.length; i+=2) { var formVal = MM_fields[i+1]; var MM_typesArray = MM_columns[i+1].split(","); var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : ""; var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : ""; var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : ""; if (formVal == "" || formVal == "undefined") { formVal = emptyVal; } else { if (altVal != "") { formVal = altVal; } else if (delim == "'") { // escape quotes formVal = "'" + formVal.replace(/'/g,"''") + "'"; } else { formVal = delim + formVal + delim; } } MM_tableValues += ((i != 0) ? "," : "") + MM_columns[i]; MM_dbValues += ((i != 0) ? "," : "") + formVal; } MM_editQuery = "insert into " + MM_editTable + " (" + MM_tableValues + ") values (" + MM_dbValues + ")"; if (!MM_abortEdit) { // execute the insert var MM_editCmd = Server.CreateObject('ADODB.Command'); MM_editCmd.ActiveConnection = MM_editConnection; MM_editCmd.CommandText = MM_editQuery; MM_editCmd.Execute(); MM_editCmd.ActiveConnection.Close(); if (MM_editRedirectUrl) { Response.Redirect(MM_editRedirectUrl); } } } %> Weymouth Troop 9 World War II Memorial
Home
Register a Veteran
Search the Registry
About the Project
 


Please use the form below to register a veteran who was a Weymouth resident during World War II and who served in the war or to provide information about a veteran who is presently in our database but is missing detail. To see if your veteran is already in our database use our Search the Registry page.

Your contact information is important so that we can make follow up calls or emails if needed to insure the quality of the information. With your help we can make the Weymouth World War II memorial a lasting tribute to the veterans of the "Greatest Generation" who gave so much so that we could all live in freedom.

Your contact information:

*required

First Name*:

Last Name*:

email:

Phone*:

Weymouth World War II Veteran to be honored:

Veteran's First Name*:

Veteran's Last Name*:

Veteran's Full Name*:

Rank:

Status:

Branch:

World War II Activities/Awards:

Additional Information:

 

 

    Home | Register a Veteran | Search the Registry | About the Project