<%@LANGUAGE="JAVASCRIPT"%> <% // *** Edit Operations: declare variables // set the form action variable var MM_editAction = Request.ServerVariables("URL"); 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")) != "undefined") { var MM_editConnection = MM_SpeakerRequest_STRING; var MM_editTable = "Speakrequest"; var MM_editRedirectUrl = "Thankyou.asp"; var MM_fieldsStr = "Contact_Firstname|value|Contact_Lastname|value|Contact_Title|value|Contact_Phone|value|Contact_Email|value|Contact_Org|value|Contact_Country|value|Event_Name|value|Event_Location|value|Event_Date|value|Speak_Desc|value|Audience_Desc|value"; var MM_columnsStr = "Contact_Firstname|',none,''|Contact_Lastname|',none,''|Contact_Title|',none,''|Contact_Phone|',none,''|Contact_Email|',none,''|Contact_Org|',none,''|Contact_Country|',none,''|Event_Name|',none,''|Event_Location|',none,''|Event_Date|',none,''|Speak_Desc|',none,''|Audience_Desc|',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.length > 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); } } } %> Bill Toomey Official Web Site - Speaker - Book Bill
 
        

     
Please send an email to Bill at inquiry@bill-toomey.com and include your contact information, a description of the speaking event, the date you would like Bill to present and any other pertinent information. Bill's representatives will contact you within a few business days after receiving your request to discuss your requirements, his availability, applicable fees and logistics.

 
     
 

© Copyright 2001 William A. Toomey. All rights reserved

This website is the only official website of William "Bill" Toomey. Commercial reproduction, distribution or transmission of any part of this website or any information contained herein by any means whatsoever without the prior written permission of William "Bill" Toomey is not permitted.