28,406
社区成员
发帖
与我相关
我的任务
分享ADODB.Field (0x800A0BCD)BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
错误类型：
ADODB.Field (0x800A0BCD)
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
/jlxx.asp, 第 38 行
第38行代码： <td align="left" width="50%"><%=(Recordset1.Fields.Item("编号").Value)%></td>
整页代码：<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/web.asp" -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("编号") <> "") Then
Recordset1__MMColParam = Request.QueryString("编号")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_web_STRING
Recordset1.Source = "SELECT * FROM conn WHERE 编号 = " + Replace(Recordset1__MMColParam, "'", "''") + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
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=gb2312" />
<title>无标题文档</title>
</head>
<body>
<table align="center" border="1">
<tr>
<td align="left" width="50%">编号</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("编号").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">用户名</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("用户名").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">密码</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("密码").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">电子邮件</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("电子邮件").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">是否愿意</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("是否愿意").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">附言</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("附言").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">知道本站</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("知道本站").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">注册时间</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("注册时间").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">IP</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("IP").Value)%></td>
</tr>
</table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
ADODB.Field (0x800A0BCD)
BOF 或 EOF 中有一个是“真”，或者当前的记录已被删除，所需的操作要求一个当前的记录。
/jlxx.asp, 第 38 行
第38行代码： <td align="left" width="50%"><%=(Recordset1.Fields.Item("编号").Value)%></td>
整页代码：<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/web.asp" -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("编号") <> "") Then
Recordset1__MMColParam = Request.QueryString("编号")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_web_STRING
Recordset1.Source = "SELECT * FROM conn WHERE 编号 = " + Replace(Recordset1__MMColParam, "'", "''") + ""
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
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=gb2312" />
<title>无标题文档</title>
</head>
<body>
<table align="center" border="1">
<tr>
<td align="left" width="50%">编号</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("编号").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">用户名</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("用户名").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">密码</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("密码").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">电子邮件</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("电子邮件").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">是否愿意</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("是否愿意").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">附言</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("附言").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">知道本站</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("知道本站").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">注册时间</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("注册时间").Value)%></td>
</tr>
<tr>
<td align="left" width="50%">IP</td>
<td align="left" width="50%"><%=(Recordset1.Fields.Item("IP").Value)%></td>
</tr>
</table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
...全文
请发表友善的回复…
发表回复
