<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%> <% // *** 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")) == "form2") { var MM_editConnection = MM_guestbook3_STRING; var MM_editTable = "guestbook"; var MM_editRedirectUrl = ""; var MM_fieldsStr = "name|value|job|value|adress|value|tel|value|email|value|title|value|message|value"; var MM_columnsStr = "name|',none,''|job|',none,''|adress|',none,''|tel|none,none,NULL|email|',none,''|title|',none,''|message|',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); } } } %>

设为首页   加入收藏    联系我们
网站地图
卫生概况   机构职能   政策法规 国家法律法规 地方法规规章 卫生厅局文件 行政许可 卫生许可受理范围 卫生许可办理须知 卫生许可目录 行政许可程序规定 行政许可公示 其它 热点专题 新型农村合作医疗 创卫工作 社区卫生 网上服务 网上查询 办事指南 健康知识 其它 文件公告 卫生部 省卫生厅 市卫生局 统计数据 统计数据 统计公报 政民互动 局长信箱 公众问答 征求意见
返回首页
本站首页 | 关于我们 | 网站地图 | 版权：西部卓越网 2006-2007  技术支持：西部卓越网