ASP (0x80040E14)

来源：百度知道 编辑：UC知道 时间：2024/06/14 05:46:59
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/zhuce.asp, 第 28 行

<%
If (CStr(Request("MM_insert")) = "form1") Then
If (Not MM_abortEdit) Then
' execute the insert
Dim MM_editCmd

Set MM_editCmd = Server.CreateObject ("ADODB.Command")
MM_editCmd.ActiveConnection = MM_conn_STRING
MM_editCmd.CommandText = "INSERT INTO zhuce (name, password, address, email) VALUES (?, ?, ?, ?)"
MM_editCmd.Prepared = true
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("name")) ' adVarWChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 50, Request.Form("password")) ' adVarWChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 50, Request.Form("address")) ' adVa

查数据库里 zhuce 表里 name, password, address, email 四个字段是不是文本型,文本长度限制,是否可以为空

建议自己写代码，用DM生成的代码自己改起来不方便

一般来说是数据数形不对导致的,要么改数据库的类型,要么ASP强制转换数据类型.