INSERT INTO 语句的语法错误，急救！！！解决再加50

来源：百度知道编辑：UC知道时间：2024/04/27 21:10:10

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/index.asp, 第 115 行
代码如下）受字数限制（有略
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

<%
' *** Edit Operations: declare variables

Dim 略MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If
' boolean to abort record edit
MM_abortEdit = false
' query string to execute
MM_editQuery = ""
%>
<%
' *** Insert Record: set variables
If (CStr(Request("MM_insert")) = "form1") Then
MM_editConnection = MM_gyp_STRING
MM_editTable = "biao"
MM_editRedirect

MM_dbValues 前后少单引号。

改成这样
MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values ('" & MM_dbValues & "')"

我觉得是你的关于MM_dbValues的表字段长度设少了.增加一下字段的长度应该可以解决

应该是你的字符型数据设置成文本了...改为备注就讷讷感解决你所遇到的问题

INSERT INTO 语句的语法错误。 Insert Into 语句的语法错误 INSERT INTO 语句的语法错误??conn.execute INSERT INTO 语句的语法错误，高手来帮个忙啊！怎样解决INSERT INTO 语句的语法错误 [求助]INSERT INTO 语句的语法错误。 INSERT INTO 语句的语法错误。asp ASP INSERT INTO 语句的语法错误如何解决 INSERT INTO 语句的语法错误 Insert into 语句语法错误