%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%> <% // *** Edit Operations: declare variables // set the form action variable var MM_editAction = Request.ServerVariables("SCRIPT_NAME"); if (Request.QueryString) { MM_editAction += "?" + Server.HTMLEncode(Request.QueryString); } // boolean to abort record edit var MM_abortEdit = false; %> <% if (String(Request("MM_insert")) == "SignUp") { if (!MM_abortEdit) { // execute the insert var MM_editCmd = Server.CreateObject ("ADODB.Command"); MM_editCmd.ActiveConnection = MM_results_STRING; MM_editCmd.CommandText = "INSERT INTO Registration (UserDate, FirstName, LastName, UserEmail, UserAddress, UserCity, UserState, UserZip, UserSynod, Conference, Attendees) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; MM_editCmd.Prepared = true; MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("UserDate"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param2", 202, 1, 50, Request.Form("FirstName"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param3", 202, 1, 50, Request.Form("LastName"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param4", 202, 1, 50, Request.Form("UserEmail"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param5", 202, 1, 50, Request.Form("UserAddress"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param6", 202, 1, 50, Request.Form("UserCity"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param7", 202, 1, 50, Request.Form("UserState"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param8", 202, 1, 50, Request.Form("UserZip"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param9", 202, 1, 50, Request.Form("UserSynod"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param10", 202, 1, 50, Request.Form("Conference"))); // adVarWChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param11", 202, 1, 50, Request.Form("Attendees"))); // adVarWChar MM_editCmd.Execute(); MM_editCmd.ActiveConnection.Close(); // append the query string to the redirect URL var MM_editRedirectUrl = "confirmation.html"; if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) { MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1) ? "?" : "&") + Request.QueryString; } Response.Redirect(MM_editRedirectUrl) } } %>
| Sign Up for NRIT conferences | |