又是我啊，求大神帮我看下我的语句哪里错了

shootboot · 发表于 2012-4-17 22:59:43

本帖最后由 shootboot 于 2012-4-17 23:08 编辑

技术信息（用于支持人员）

错误类型：
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/aspmaker/join.asp, 第 28 行
已经加红的那条

第28行 MM_editCmd.Execute

<%
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_mymembers_STRING
MM_editCmd.CommandText = "INSERT INTO [join] (email, id, name, password) VALUES (?, ?, ?, ?)"
MM_editCmd.Prepared = true
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 201, 1, -1, Request.Form("email")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 201, 1, -1, Request.Form("id")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 201, 1, -1, Request.Form("name")) ' adLongVarChar
MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 201, 1, -1, Request.Form("password")) ' adLongVarChar
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close
' append the query string to the redirect URL
Dim MM_editRedirectUrl
MM_editRedirectUrl = "/aspmaker/joinok.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
%>
<!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>
<table width="1024" border="1" align="center">
  <tr>
<td><img src="img/banner.gif" alt="1" width="1024" height="445" /></td>
  </tr>

</table>
</table>
<table width="1024" align="center">
  <tr>
<td> 
   <form action="<%=MM_editAction%>" method="post" name="form1" id="form1">
      <table align="center">
      <tr valign="baseline">
         <td nowrap="nowrap" align="right">邮箱</td>
         <td><input type="text" name="email" value="" size="32" /></td>
      </tr>
      <tr valign="baseline">
         <td nowrap="nowrap" align="right">Id:</td>
         <td><input type="text" name="id" value="" size="32" /></td>
      </tr>
      <tr valign="baseline">
         <td nowrap="nowrap" align="right">用户名</td>
         <td><input type="text" name="name" value="" size="32" /></td>
      </tr>
      <tr valign="baseline">
         <td nowrap="nowrap" align="right">密码</td>
         <td><input type="password" name="password" value="" size="32" /></td>
      </tr>
      <tr valign="baseline">
         <td nowrap="nowrap" align="right"> </td>
         <td><input type="submit" value="注册" /></td>
      </tr>
      </table>
      <input type="hidden" name="MM_insert" value="form1" />
   </form>
<p> </p></td>
  </tr>
</table>
<table width="1024" align="center">
  <tr> </tr>
</table>
<table width="1024" align="center">
  <tr>
<td><img src="img/logo.gif" alt="2" width="1018" height="40" /></td>
  </tr>
</table>
<center>
  <bottom>
<div "apDiv2">
   <p class="bottomfont"><a href="http://www.nit.edu.cn/">学校主页</a>丨<a href="http://eapp.nit.edu.cn/portal/home.do?method=index">数字校园</a>丨<a href="homepage.html">班级主页</a>丨<a href="http://tieba.baidu.com">百度贴吧</a></p>
   <p class="bottomfont">Copyright 2012 Tofumelon All right reserve</p>
   <p class="bottomfont">2010通信技术</p>
</div>
  </bottom>
</center>
<table width="1024" border="0" align="right" class="line">
  <tr> </tr>
</table>
</body>
</html>

		自动登录	找回密码
密码			立即注册

[其他（请注明）] 又是我啊，求大神帮我看下我的语句哪里错了

站长推荐 /1