一个ASP的问题 在线等
页面显示
错误类型：
ADODB.Field (0x80020009)
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
/page/ment1.asp
代码如下：
<%@ LANGUAGE= "VBSCRIPT " %>
<!--#include file= "conn.asp " -->
<%
set Rs = Server.CreateObject( "ADODB.recordset ")
sql= "select * from [user] where id= ' "&Id& " ' "
rs.open sql,conn,1,1
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN ">
<HTML> <HEAD> <TITLE> 商品结算 </TITLE>
<META http-equiv=Content-Type content= "text/html; charset=gb2312 ">
<META content= "Microsoft FrontPage 4.0 " name=GENERATOR>
</HEAD>
<BODY>
<DIV align=center>
<p> </p>
<FORM name= "FORM1 " onSubmit= "return FORM1_onsubmit() "
action= "record.asp " method= "post ">
<INPUT type= "hidden "value= " <%=rs( "id ")%> " name= "UserId ">
<TABLE cellSpacing=0 cellPadding=0 width=362>
<TBODY>
<TR>
<TD align=middle width= "372 ">
<TABLE width=388 border= "0 " cellPadding=5 cellSpacing=1 bgColor=#5A8BCE>
<TBODY>
<TR vAlign=top bgColor=#E6F7FF>
<TD width= "374 " colSpan=2>
<p align= "center " class= "style1 "> 购物结算--(第一步)收货人信息 </p> </TD>
</TR>
<TR bgColor=#eeeeee>
<TD width=103 bgColor=#EEEEEE height=7 align= "right ">
<p align= "center "> 收货人姓名： </p>
</TD>
<TD width=259 height=7 bgcolor= "#EEEEEE ">
<p> <INPUT name= "Name " class= "smallInput " style= "font-size: 14px " value= " <%=rs( "Name ")%> " size= "13 " maxLength=16>
</p>
</TD> </TR>
<tr>
<TD width=103 bgColor=#EEEEEE height=7 align= "right ">
<p align= "center "> 收货人地址 <SPAN
> ： </SPAN> </p>
</TD>
<TD width=259 height=7 bgcolor= "#EEEEEE ">
<p align= "center ">
<INPUT name= "Address " class= "smallInput " style= "font-size: 14px " value= " <%=rs( "Address ")%> " size=36 maxLength=16 >
</p>
</TD>
</tr>
<tr>
<TD width=103 bgColor=#EEEEEE height=7 align= "right ">
<p align= "center "> 邮政编码： </p>
</TD>
<TD width=259 height=7 bgcolor= "#EEEEEE ">
<p> <INPUT
name= "Zip " class= "smallInput " style= "font-size: 14px " value= " <%=rs( "zipcode ")%> " size=13 maxLength=16>
</p>
</TD>
</tr>
<tr>
<TD width=103 bgColor=#EEEEEE height=7 align= "right ">
<p align= "center "> 联系电话： </p>
</TD>
<TD width=259 height=7 bgcolor= "#EEEEEE ">
<p> <INPUT
name= "Phone " class= "smallInput " style= "font-size: 14px " value= " <%=rs( "Phone ")%> " size=23 maxLength=16>
</p>
</TD>
</tr>
<tr>
<TD width=103 bgColor=#EEEEEE height=7 align= "right ">
<p align= "center "> 电子信箱： </p>
</TD>
<TD width=259 height=7 bgcolor= "#EEEEEE ">
<p> <INPUT
name= "Email " class= "smallInput " style= "font-size: 14px " value= " <%=rs( "mail ")%> " size=32 maxLength=16>
</p>
</TD>
</tr>
<TR vAlign=top bgColor=#eeeeee>
<TD colSpan=2 width= "374 " bgcolor= "#EEEEEE ">
<p align= "center "> 你可以修改以上内容 </TD> </TR>
<TR bgColor=#E6F7FF>
<TD colSpan=2 width= "374 ">
<DIV align=center>
<p align= "center ">
<INPUT "class=smallInput " type= "submit " size=3 value=下一步 name= "Submit2 ">
</DIV> </TD> </TR> </TBODY> </TABLE>
</TD> </TR> </TBODY> </TABLE>
<p align= "center "> <BR> </FORM> </DIV> </BODY> </HTML>
<%
rs.close
conn.close
%>
但我与数据库校对过 <%%> 里的东西没错 没有连错表.....
是什么问题 请指教～～～
[解决办法]
没有判断记录是否存在
rs.open sql,conn,1,1
改为
rs.open sql,conn,1,1
if not rs.eof then
'--------------------
rs.close
改为
end if
rs.close
