用Dw cs6创建网站，向数据库插入记录时出错？请哪位大侠帮帮忙！

Dwcs6创建网站，向数据库插入记录时出错？请哪位大侠帮帮忙！错误类型：MicrosoftJETDatabaseEngine(0x80040E14)INSERTINTO语... Dw cs6创建网站，向数据库插入记录时出错？请哪位大侠帮帮忙！
错误类型：
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/zhuce.asp, 第 26 行
代码如下：
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

<%
Dim MM_editAction
MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME"))
If (Request.QueryString <> "") Then
MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString)
End If
' boolean to abort record edit
Dim MM_abortEdit
MM_abortEdit = false
%>
<%
If (CStr(Request("MM_insert")) = "form1") Then
If (Not MM_abortEdit) Then
' execute the insert
Dim MM_editCmd
Set MM_editCmd = Server.CreateObject ("ADODB.Command")
MM_editCmd.ActiveConnection = MM_zclj_STRING
MM_editCmd.CommandText = "INSERT INTO zhuce (username, password) VALUES (?, ?)"
MM_editCmd.Prepared = true
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 50, Request.Form("usname")) ' adVarWChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 15, Request.Form("pwd")) ' adVarWChar
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
' append the query string to the redirect URL
Dim MM_editRedirectUrl
MM_editRedirectUrl = "zhuceover.asp"
If (Request.QueryString <> "") Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If
Response.Redirect(MM_editRedirectUrl)
End If
End If
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_zclj_STRING
Recordset1_cmd.CommandText = "SELECT * FROM zhuce"
Recordset1_cmd.Prepared = true
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>
<body>
<form id="form1" name="form1" method="POST" action="<%=MM_editAction%>">
<p>
<label for="usname">会员名</label>
<input type="text" name="usname" id="usname" />
</p>
<p>
<label for="pwd">密码</label>
<input type="text" name="pwd" id="pwd" />
</p>
<p> </p>
<p>
<input type="submit" name="button" id="button" value="提交" />
</p>
<input type="hidden" name="MM_insert" value="form1" />
</form>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
最怪的是如果只把一个文本域的值插入数据表中，则不会出错，这儿我要求对应两个文本域的值同时插入数据表的对应字段，则总是通不过？望那位老师指点指点！。展开

 我来答

1个回答

#热议# 普通体检能查出癌症吗？

AiPPT
2024-09-19 广告

随着AI技术的飞速发展，如今市面上涌现了许多实用易操作的AI生成工具1、简介：AiPPT: 这款AI工具智能理解用户输入的主题，提供“AI智能生成”和“导入本地大纲”的选项，生成的PPT内容丰富多样，可自由编辑和添加元素，图表类型包括柱状图... 点击进入详情页

本回答由AiPPT提供

推荐律师服务：若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询

用Dw cs6创建网站，向数据库插入记录时出错？请哪 位大侠帮帮忙！

其他类似问题

为你推荐：

用Dw cs6创建网站，向数据库插入记录时出错？请哪位大侠帮帮忙！