<% Dim MM_editAction MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit Dim MM_abortEdit MM_abortEdit = false %> <% If (CStr(Request("MM_insert")) = "form1") Then If (Not MM_abortEdit) Then ' execute the insert Dim MM_editCmd Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_grantconn_STRING MM_editCmd.CommandText = "INSERT INTO dbo.Conference (UserFirstName, UserLastName, UserEmail_1, UserEmail_2, UserPhone_1, UserPhone_2, UserOrganization, UserTitle, UserAddress_1, UserAddress_2, UserAddress_3, PaymentCat, ConfName, ConfYear, ConfMonth, DateRegistered) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" MM_editCmd.Prepared = true MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 201, 1, 50, Request.Form("UserFirstName")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 201, 1, 50, Request.Form("UserLastName")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 201, 1, 50, Request.Form("UserEmail_1")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 201, 1, 50, Request.Form("UserEmail_2")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 201, 1, 50, Request.Form("UserPhone_1")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 201, 1, 50, Request.Form("UserPhone_2")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 201, 1, 150, Request.Form("UserOrganization")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 201, 1, 100, Request.Form("UserTitle")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 201, 1, 100, Request.Form("UserAddress_1")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 201, 1, 100, Request.Form("UserAddress_2")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 201, 1, 100, Request.Form("UserAddress_3")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param12", 201, 1, 100, Request.Form("PaymentCat")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param13", 201, 1, 300, Request.Form("ConfName")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param14", 3, 1, 8, Request.Form("ConfYear")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param15", 3, 1, 8, Request.Form("ConfMonth")) ' adLongVarChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param16", 135, 1, 8, Now) MM_editCmd.Execute MM_editCmd.ActiveConnection.Close ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "registration.asp" If (Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If 'Response.Redirect(MM_editRedirectUrl) End If End If %>