高手快进来啊,帮我看看是什么问题?(页 1) - WEB 开发 - 破釜沉舟论坛平面设计,Web 开发,手绘技术,Flash,灌水乐园

2006-4-8 15:57 wxqjscs

高手快进来啊,帮我看看是什么问题?

·    错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] 操作必须使用一个可更新的查询。
/zhuceyemian.asp, 第 141 行
·    浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MyIE2)
·    网页：
POST 189 ??? /zhuceyemian.asp
·    POST Data:
name=%CD%F5%B9%A5&Password=222222&Company=%BD%AD%CB%D5%CA%A1&tel=52206733&mail=&postcode+=215500&Address=%BD%AD%CB%D5%CA%A1&Submit=%CC%E1%BD%BB&regtime=2006-4-8+15%3A38%3A29&MM_insert=form1

[color=darkblue][color=darkblue][size=4]这是在注册提交后跳出来的页面上的错误提示,请问我哪里错了啊[/size][/color][/color]

2006-4-8 16:05 wxqjscs

咋没人来理我的啊 [s:38]

2006-4-8 21:59 zhangsent

方便把代码贴出来吗`！？

2006-4-8 22:01 zhangsent

看看这个~！
[url]http://bbs.7880.com/read.php?tid=3922&keyword=[/url]

2006-4-9 08:37 wxqjscs

这是我的代码


<%
' *** Validate request to log in to this site.
MM_LoginAction = Request.ServerVariables("URL")
If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Server.HTMLEncode(Request.QueryString)
MM_valUsername=CStr(Request.Form("name"))
If MM_valUsername <> "" Then
  MM_fldUserAuthorization="ID"
  MM_redirectLoginSuccess="/luntanjiaoliu.asp"
  MM_redirectLoginFailed="/denglucuowu.asp"
  MM_flag="ADODB.Recordset"
  set MM_rsUser = Server.CreateObject(MM_flag)
  MM_rsUser.ActiveConnection = MM_all_STRING
  MM_rsUser.Source = "SELECT name, Password"
  If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization
  MM_rsUser.Source = MM_rsUser.Source & " FROM user2 WHERE name='" & Replace(MM_valUsername,"'","''") &"' AND Password='" & Replace(Request.Form("Password"),"'","''") & "'"
  MM_rsUser.CursorType = 0
  MM_rsUser.CursorLocation = 2
  MM_rsUser.LockType = 3
  MM_rsUser.Open
  If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
   ' username and password match - this is a valid user
   Session("MM_Username") = MM_valUsername
   If (MM_fldUserAuthorization <> "") Then
     Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value)
   Else
     Session("MM_UserAuthorization") = ""
   End If
   if CStr(Request.QueryString("accessdenied")) <> "" And true Then
     MM_redirectLoginSuccess = Request.QueryString("accessdenied")
   End If
   MM_rsUser.Close
   Response.Redirect(MM_redirectLoginSuccess)
  End If
  MM_rsUser.Close
  Response.Redirect(MM_redirectLoginFailed)
End If
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>百岁老人头</title>
<style type="text/css">

</style>
<script language="JavaScript">

</script>
<script language="JavaScript" src="mm_menu.js"></script>
<link href="/css1.css" rel="stylesheet" type="text/css">
</head>

<body>
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="720" height="389" border="0" align="center" cellpadding="0" cellspacing="0" class="table-bg">
  <tr>
   <td height="100" colspan="2"> </td>
  </tr>
  <tr align="right" bgcolor="#333333">
   <td height="13" colspan="2"><span class="style10">· 客户反馈 ·</span> </td>
  </tr>
  <tr align="center" valign="middle" bgcolor="#1F1F1F">
   <td height="93" colspan="2"><p align="left" class="style1"> </p></td>
  </tr>
  <tr align="center" valign="middle" bgcolor="#1F1F1F">
   <td height="107" colspan="2"><form action="<%=MM_LoginAction%>" method="POST" name="form1" class="style1">
   <table width="199" border="0">
     <tr>
     <td width="72" height="35" align="left"><span class="style30">用户名</span></td>
     <td width="117"><input name="name" type="text" id="name" size="16"></td>
     </tr>
     <tr>
     <td height="35" align="left"><span class="style30">密  码</span></td>
     <td><input name="Password" type="password" id="Password" size="16"></td>
     </tr>
     <tr>
     <td height="35" colspan="2" align="center"><input type="submit" name="Submit" value="登陆">
           <span class="style32"><a href="/zhuceyemian.asp">注册</a></span> </td>
     </tr>
   </table>
   </form></td>
  </tr>
  <tr align="center" valign="middle" bgcolor="#1F1F1F">
   <td height="40" colspan="2"> </td>
  </tr>
  <tr>
   <td width="112" rowspan="2" bgcolor="#333333"><img src="gongsijianjie/logo.png" width="112" height="99"></td>
   <td height="13" align="center" bgcolor="#333333"><table width="606" height="12" border="0">
     <tr>
         <td height="13" align="center"><a href="shouye.asp"><img src="sy.gif" width="27" height="12" border="0"></a></td>
         <td align="center"><a href="gongsijianjie.asp"><img src="gsjj.gif" width="58" height="12" border="0"></a></td>
         <td align="center"><a href="shishangxinpin.asp"><img src="ssxp.gif" width="56" height="12" border="0"></a></td>
         <td align="center"><a href="kehujiameng.asp" onMouseOver="MM_showMenu(window.mm_menu_0329084443_0,-50,30,null,'image1')" onMouseOut="MM_startTimeout();"><img src="yyhz.gif" name="image1" width="58" height="12" border="0" id="image1"></a></td>
         <td align="center"><a href="denglu.asp"><img src="khfk.gif" width="58" height="12" border="0"></a></td>
         <td align="center"><a href="lianluofangshi.asp"><img src="llfs_f2.gif" width="58" height="12" border="0"></a></td>
     </tr>
   </table></td>
  </tr>
  <tr>
   <td height="16" bgcolor="#1F1F1F"> </td>
  </tr>
</table>
</body>
</html>

2006-4-10 16:46 wxqjscs

高手们都去哪了啊 ,贴了都几天了,怎么都没人来指点一下啊 [s:38]

2006-4-10 16:59 路人甲

操作必须使用一个可更新的查询

论坛里面有很多人都提了这个问题的

仔细找找吧
看看你是否拥有数据库读写权限
你的代码中是否符合读写逻辑等

2006-4-11 16:38 wxqjscs

找了好久啊,没找到啊,呵呵,能不能在这里指点一下啊,拜托了啊