数据库mysql字段加换行_如何使数据库中备注字段能够换行显示出来，急急急

第一个数据记录插入程序

// *** Edit Operations: declare variables

// set the form action variable

var MM_editAction = Request.ServerVariables("SCRIPT_NAME");

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")) == "form1") {

var MM_editConnection = MM_q_STRING;

var MM_editTable  = "文稿库";

var MM_editRedirectUrl = "/1-ENTER.ASP";

var MM_fieldsStr = "bt|value|writer|value|hz|value|tzy|value|select|value|select2|value|ty|value|nr|value";

var MM_columnsStr = "标题|',none,''|报道署名|',none,''|摄像|',none,''|通讯员|',none,''|文稿类别|',none,''|类型|',none,''|提要|',none,''|内容|',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);

}

}

}

%>

无标题文档

文稿录入 文章标题 作者 " size="18"> 合作者 通讯员 文稿类别 新闻 专栏 文稿类型 农业 工业 公检法 时政 其它 提要 作者: 黄岩密桔 发布时间: 2004-04-22