人寿保险险种介绍少儿:做管理页面密码更改的问题,请高手解决啊

来源:百度文库 编辑:神马品牌网 时间:2024/04/23 18:31:36
用dreamweaver MX和access做的
在管理员修改密码界面使用的是服务器选项更改记录
access的相关表格就是username-admin,和password-admin
请哪位看看问题啊?感谢
出错提示:技术信息(用于支持人员)

错误类型:
Microsoft JET Database Engine (0x80040E14)
UPDATE 语句的语法错误。
/design/passman.asp, 第 133 行

浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
网页:
POST 100 ??? /design/passman.asp
POST Data:
txtNewPass=123&txtPassAgain=123&Submit=%CC%E1++%BD%BB&MM_update=form1&MM_recordId=&MM_recordId=admin
If (CStr(Request("MM_update")) <> "" And CStr(Request("MM_recordId")) <> "") Then

' create the sql update statement
MM_editQuery = "update " & MM_editTable & " set "
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_formVal = MM_fields(MM_i+1)
MM_typeArray = Split(MM_columns(MM_i+1),",")
MM_delim = MM_typeArray(0)
If (MM_delim = "none") Then MM_delim = ""
MM_altVal = MM_typeArray(1)
If (MM_altVal = "none") Then MM_altVal = ""
MM_emptyVal = MM_typeArray(2)
If (MM_emptyVal = "none") Then MM_emptyVal = ""
If (MM_formVal = "") Then
MM_formVal = MM_emptyVal
Else
If (MM_altVal <> "") Then
MM_formVal = MM_altVal
ElseIf (MM_delim = "'") Then ' escape quotes
MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'"
Else
MM_formVal = MM_delim + MM_formVal + MM_delim
End If
End If

把源码也贴出来嘛....

重要的是你的SQL语句.