
用Dreamweaver做网页,总报错!(asp+access)
错误类型:MicrosoftJETDatabaseEngine(0x80040E14)UPDATE语句的语法错误。我用的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 展开
我用的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 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询