注册 登录
编程论坛 ASP技术论坛

麻烦各位大大了 MM_editCmd.Execute 错误

zjh1028 发布于 2011-05-11 23:14, 405 次点击
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。

MM_editCmd.Execute这条错误。。。这条周围的程序是:
MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")"

  If (Not MM_abortEdit) Then
    ' execute the insert
    Set MM_editCmd = Server.CreateObject(")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_ = MM_editQuery
     MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    If (MM_editRedirectUrl <> "") Then
      Response.Redirect(MM_editRedirectUrl)
2 回复
#2
zjh10282011-05-12 10:39
难道没人能回我么。。。
#3
dzt00012011-05-12 10:50
都有提示是“INSERT INTO 语句的语法错误”,你检查一下是不是SQL语句不对
1