
用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 展开
1个回答
展开全部
把你的更新语句发上来看看有没有错误。
好象这句有问题:
MM_columnsStr = "Title|',none,''|Content|',none,''|Date|#,none,NULL"有问题
你把UPDATE语句附近的代码发上来
好象这句有问题:
MM_columnsStr = "Title|',none,''|Content|',none,''|Date|#,none,NULL"有问题
你把UPDATE语句附近的代码发上来
已赞过
已踩过<
评论
收起
你对这个回答的评价是?

2025-03-10 广告
批量创建广告,可以试用小鹿管家。小鹿管家是广告批量管理工具,支持快速多账户搭建计划、跨账户复制计划、智能盯盘、多账户报告聚合等提效功能,助力广告投放效率,监控广告投放效果,提升ROI。通过批量创建、智能提醒、BI报表等技术手段帮助广告运营团...
点击进入详情页
本回答由小鹿管家提供
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询