Question

网页制作ASP出错

Microsoft JET Database Engine (0x80040E14)
UPDATE 语句的语法错误
部分代码如下：
<%
If (CStr(Request("MM_update")) = "form1") Then
If (Not MM_abortEdit) Then
' execute the update
Dim MM_editCmd

Set MM_editCmd = Server.CreateObject ("ADODB.Command")
MM_editCmd.ActiveConnection = MM_conn_STRING
MM_editCmd.CommandText = "UPDATE [admin] SET password = ? WHERE [admin] ='admin"
MM_editCmd.Prepared = true
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 201, 1, -1, Request.Form("password")) ' adLongVarChar
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
帮帮忙，谢谢！
"UPDATE [admin] SET password = ? WHERE [admin] ='admin"这句改为"UPDATE [admin] SET password = ? WHERE [admin] ='admin'"还是运行不得。

Answer 1

改为"UPDATE [admin] SET password = '?' WHERE [admin] ='admin'"
如果还有问题，你看看数据表里admin一项的字段名是什么，把[admin]外边的中括号去掉试试

Answer 2

"UPDATE [admin] SET password = ? WHERE [admin] ='admin"

从语法来说 最后少个单引号