Question

用Dreamweaver做网页，总报错！（asp＋access）

错误类型：Microsoft JET Database Engine (0x80040E14)UPDATE 语句的语法错误。
我用的access数据库，数据表里有一个属性类型是时间，就是这个不能更新。求各位大虾指点
If (CStr(Request("MM_update")) = "form1" And CStr(Request("MM_recordId")) <> "") Then
MM_editConnection = MM_connNews_STRING
MM_editTable = "News"
MM_editColumn = "NewsID"
MM_recordId = "" + Request.Form("MM_recordId") + ""
MM_editRedirectUrl = "Newslist.asp"
MM_fieldsStr = "NewsTitle|value|NewsContent|value|Newsdate|value"
MM_columnsStr = "Title|',none,''|Content|',none,''|Date|#,none,NULL"

MM_fields = Split(MM_fieldsStr, "|")
MM_columns = Split(MM_columnsStr, "|")
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
Next

If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If
End If

Answer 1

把你的更新语句发上来看看有没有错误。

好象这句有问题：
MM_columnsStr = "Title|',none,''|Content|',none,''|Date|#,none,NULL"有问题

你把UPDATE语句附近的代码发上来