<%@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; // query string to execute var MM_editQuery = ""; %> <% // *** Insert Record: set variables if (String(Request("MM_insert")) == "pryForm") { var MM_editConnection = MM_elifeconn_STRING; var MM_editTable = "Prayer"; var MM_editRedirectUrl = "thanx.htm"; var MM_fieldsStr = "names|value|tellNumber|value|email|value|pryRq1|value|pryRq2|value|pryRq3|value"; var MM_columnsStr = "Name|',none,''|Phone|none,none,NULL|Address|',none,''|pry1|',none,''|pry2|',none,''|Pry3|',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); } } } %> prayer_room

Welcome to elifeonline.com Opinion of this magazine Contact us. Help us to get better. Send us your opinion. Can you write? Send in your articles. Meet us. Daily devotional and prayer requests.
Our contributors Support us to serve you better.
Other websites by Livingprojects Media Network. What we can do for you. Reactions from all over the world to the first edition.
Advertise your products with us. Encourage others with your testimonies.

Read our maiden edition. Do you need help on challenges confronting you? Discussion forum where personalised questions are asked and advices given. Weekly word study from the Bible. Clean Christian Jokes, Weekly Quotes and thoughtful African Proverbs. Weekly Christian news from all Africa. Move up the ladder of life through these websites.

here
Home .l .About us. l. Feedback. l. Prayer room. l .Our sites. l .Bookstand. l. Support us. l . Reactions to July edition. l .Jokes
Contact us. l .Submit articles. l. Testimonies. l .Discussion Board . l Are you in Crisis?. l .News. l .Quotes. l .Proverbs