您所在位置：主题：ASP修改数据裤的出现BOF或EOF问题
wjkyo0000
[专家分：0] 发布于 2007-12-13 15:35:00
vipgyjc.asp
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
rs.open "SELECT * FROM buyer WHERE buyer.username='"&request.querystring("username")&"' ",conn,1,1
%>
<div align="center">
<td valign="top" bgcolor="#FfFfFf" width="524" height="484" rowspan="2"><table width="80%" border="1" cellpadding="4" cellspacing="0" align=right height="552">
<tr><td colspan=2 height="16"><b>以下为基本资料：</b></td></tr>
<form action="vipedit.asp" method="post" name="form1" id="form1">
<tr>
<td width="30%" align="right" height="15">登陆帐号： </td>
<td width="70%" height="15"><%=trim(rs("username"))%></td>
</tr>
<tr>
<td align="right" height="23">真实姓名： </td>
<td height="23"><input type="text" name="buyername" value="<%=trim(rs("buyername"))%>" maxlength="16" ></td>
</tr>
<tr><td colspan=2 align=center height="25">
<input type="submit" name="Submit" value="确认修改">
<input name="Submit2" type="reset" value="重新填写">
<input type="hidden" name="buyerid" value="<%=request.querystring("username")%>">
</td>
</tr>
<td height="10"></form>
</table></td>
<td width="30" height="484" rowspan="2"></td>
</tr>
<tr>
<td height="299" colspan="2"></td>
</tr>
</table>
</div>
vipedit.asp
<!--#include file="conn.asp" -->
<%
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from buyer where username='"&request.form("username")&"'",Conn,1,3
rs_s("buyername")=request.form("buyername") //行9
ADODB.Recordset 错误 '800a0bcd'
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
/tillage/vipedit.asp，行9
rs_s.Update
username=request.form("username")
response.Redirect "vipgyjc.asp?username="&username&""
rs.Close
rs_s.Close
conn.Close
set rs=Nothing
set rs_s=Nothing
set conn=Nothing
%>
如果我把USERNAME（文本）换成BUYERID（数字）又可以~ 初学ASP 请高手帮忙看看~~
万般感谢！
<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
rs.open "SELECT * FROM buyer WHERE buyer.username='"&request.querystring("username")&"' ",conn,1,1
%>
<div align="center">
<td valign="top" bgcolor="#FfFfFf" width="524" height="484" rowspan="2"><table width="80%" border="1" cellpadding="4" cellspacing="0" align=right height="552">
<tr><td colspan=2 height="16"><b>以下为基本资料：</b></td></tr>
<form action="vipedit.asp" method="post" name="form1" id="form1">
<tr>
<td width="30%" align="right" height="15">登陆帐号： </td>
<td width="70%" height="15"><%=trim(rs("username"))%></td>
</tr>
<tr>
<td align="right" height="23">真实姓名： </td>
<td height="23"><input type="text" name="buyername" value="<%=trim(rs("buyername"))%>" maxlength="16" ></td>
</tr>
<tr><td colspan=2 align=center height="25">
<input type="submit" name="Submit" value="确认修改">
<input name="Submit2" type="reset" value="重新填写">
<input type="hidden" name="buyerid" value="<%=request.querystring("username")%>">
</td>
</tr>
<td height="10"></form>
</table></td>
<td width="30" height="484" rowspan="2"></td>
</tr>
<tr>
<td height="299" colspan="2"></td>
</tr>
</table>
</div>
vipedit.asp
<!--#include file="conn.asp" -->
<%
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from buyer where username='"&request.form("username")&"'",Conn,1,3
rs_s("buyername")=request.form("buyername") //行9
ADODB.Recordset 错误 '800a0bcd'
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
/tillage/vipedit.asp，行9
rs_s.Update
username=request.form("username")
response.Redirect "vipgyjc.asp?username="&username&""
rs.Close
rs_s.Close
conn.Close
set rs=Nothing
set rs_s=Nothing
set conn=Nothing
%>
如果我把USERNAME（文本）换成BUYERID（数字）又可以~ 初学ASP 请高手帮忙看看~~
万般感谢！
