<%@LANGUAGE="JAVASCRIPT"%> <% // *** 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")) == "form6") { if (!MM_abortEdit) { // execute the insert var MM_editCmd = Server.CreateObject ("ADODB.Command"); MM_editCmd.ActiveConnection = MM_NewsletterConn_STRING; MM_editCmd.CommandText = "INSERT INTO [Comments Database] (ID, DateJoined, FirstName, LastName, City, [State], Zip, Email, [Comment]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"; MM_editCmd.Prepared = true; MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param1", 5, 1, -1, (String(Request.Form("ID")) != "undefined" && String(Request.Form("ID")) != "") ? Request.Form("ID") : null)); // adDouble MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param2", 135, 1, -1, (String(Request.Form("DateJoined")) != "undefined" && String(Request.Form("DateJoined")) != "") ? Request.Form("DateJoined") : null)); // adDBTimeStamp MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param3", 201, 1, -1, Request.Form("FirstName"))); // adLongVarChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param4", 201, 1, -1, Request.Form("LastName"))); // adLongVarChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param5", 201, 1, -1, Request.Form("City"))); // adLongVarChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param6", 201, 1, -1, Request.Form("State"))); // adLongVarChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param7", 201, 1, -1, Request.Form("Zip"))); // adLongVarChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param8", 201, 1, -1, Request.Form("Email"))); // adLongVarChar MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param9", 201, 1, -1, Request.Form("Comment"))); // adLongVarChar MM_editCmd.Execute(); MM_editCmd.ActiveConnection.Close(); } } %> Good Company

Good Company

. . . is under construction.

A new improved site will be coming soon.

For further information contact Michael Bivona:

mbivona@goodcompany.tv