Just Skins Support Forums > Archives > Macromedia > Macromedia Dreamweaver > Dreamweaver AppDev > Either BOF or EOF is True, or the current record hasbeen deleted. Requested operation requires a current record

Either BOF or EOF is True, or the current record hasbeen deleted. Requested operation requires a current record

Posted: 03-09-2005, 03:30 PM
Choole
Guest
Posts: n/a
 
Can anyone pls help?

I am getting the following error when search my database.

"ADODB.Field (0x800A0BCD Either BOF or EOF is True, or the current record has
been deleted. Requested operation requires a current record"

"/database/Fact_Sheets/Factsheet_reponse.asp, line 75"

That particular line is = .style8 {color: #000000}

Can anyone give me any tips?

Thanks in advance

Chris

Reply With Quote

Responses to "Either BOF or EOF is True, or the current record hasbeen deleted. Requested operation requires a current record"

CMBergin
Guest
Posts: n/a
 
Re: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record
Posted: 03-09-2005, 03:44 PM
I think you picked out the wrong line. :)
You're attempting to retrieve a value from a recordset with no records.
Check your parameters, test the query, or if you know there may be
legitimately no results, wrap the part of the page with the RS data in a
"show if not empty" behavior.

"Choole" <webforumsuser@macromedia.com> wrote in message
news:d0n8at$qrl$1@forums.macromedia.com...
> Can anyone pls help?
>
> I am getting the following error when search my database.
>
> "ADODB.Field (0x800A0BCD Either BOF or EOF is True, or the current record
has
> been deleted. Requested operation requires a current record"
>
> "/database/Fact_Sheets/Factsheet_reponse.asp, line 75"
>
> That particular line is = .style8 {color: #000000}
>
> Can anyone give me any tips?
>
> Thanks in advance
>
> Chris
>

Reply With Quote
Choole
Guest
Posts: n/a
 
Re: Either BOF or EOF is True, or the current record hasbeen deleted. Requested operation requires a current record
Posted: 03-09-2005, 04:11 PM
That is defo line 75. Here is the code of the page

<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/conn_dmcl.asp" -->
<%
Dim rsFact__proj
rsFact__proj = "%"
If (request.querystring("project1") <> "") Then
rsFact__proj = request.querystring("project1")
End If
%>
<%
Dim rsFact__loc
rsFact__loc = "%"
If (request.querystring("location2") <> "") Then
rsFact__loc = request.querystring("location2")
End If
%>
<%
Dim rsFact__val
rsFact__val = "%"
If (request.querystring("value3") <> "") Then
rsFact__val = request.querystring("value3")
End If
%>
<%
Dim rsFact__indust
rsFact__indust = "%"
If (request.querystring("industry5") <> "") Then
rsFact__indust = request.querystring("industry5")
End If
%>
<%
Dim rsFact__client
rsFact__client = "%"
If (request.querystring("client4") <> "") Then
rsFact__client = request.querystring("client4")
End If
%>
<%
Dim rsFact
Dim rsFact_numRows

Set rsFact = Server.CreateObject("ADODB.Recordset")
rsFact.ActiveConnection = MM_conn_dmcl_STRING
rsFact.Source = "SELECT * FROM FactQRY WHERE project LIKE '%" +
Replace(rsFact__proj, "'", "''") + "%' AND location LIKE '%" +
Replace(rsFact__loc, "'", "''") + "%' AND mclean_value LIKE '%" +
Replace(rsFact__val, "'", "''") + "%' AND project_type LIKE '%" +
Replace(rsFact__indust, "'", "''") + "%' AND client_name LIKE '%" +
Replace(rsFact__client, "'", "''") + "%'"
rsFact.CursorType = 0
rsFact.CursorLocation = 2
rsFact.LockType = 1
rsFact.Open()

rsFact_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 1
Repeat1__index = 0
rsFact_numRows = rsFact_numRows + Repeat1__numRows
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>David McLean Contractors Project Fact Sheet</title>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.style1 {color: #FFFFFF}
.style2 {font-family: Arial, Helvetica, sans-serif}
.style3 {font-size: 12px}
.style8 {color: #000000}
.style9 {
font-size: 36px;
font-family: Arial, Helvetica, sans-serif;
color: #0000CC;
}
.style10 {color: #0076bb}
.style11 {font-family: "Trebuchet MS"}
.style12 {font-size: 12px; color: #FFFFFF; }
-->
</style>
</head>

<body>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="783" align="center" valign="top"><br>
<%
While ((Repeat1__numRows <> 0) AND (NOT rsFact.EOF))
%>
<table width="630" height="607" border="0" cellpadding="0"
cellspacing="0">
<tr>
<td align="left" valign="top">&nbsp;</td>
<td width="626" height="113" colspan="4" align="left"
valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../images/logo.gif" width="134"
height="80"></td>
<td><div align="right"><img src="../images/banner.gif"
width="447" height="80"></div></td>
</tr>
</table></td>
</tr>
<tr>
<td width="4" align="left" valign="top">&nbsp;</td>
<td colspan="4" align="left" valign="top"><p class="style9"><span
class="style10"> <%=(rsFact.Fields.Item("project").Value)%> <br>
Fact Sheet</span><span class="style3"><br>
<br>
</span></p></td>
</tr>
<tr>
<td width="4" align="left" valign="top">&nbsp;</td>
<td colspan="3" rowspan="3" align="left" valign="top"><table
width="442" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="442"
background="../images/Project-Particulars.gif"><div align="center"
class="style2"><span class="style12">Project Particulars </span></div></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="199" height="515" rowspan="3" align="left"
valign="top" background="../images/Sidebanner-factsheet.jpg"><br>
<table width="100%" height="496" border="0"
cellpadding="0" cellspacing="0">
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style1"><span class="style2"><span
class="style3"><span
class="style3">Project:</span></span></span></span></strong></div></td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span
class="style2">Location:</span></span></span></span></span></span></span></span>
</strong></div></td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span class="style2">Type of
Building:</span></span></span></span></span></span></span></span></strong></div>
</td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span class="style2">McLean Value
</span></span></span></span></span></span></span></span></strong></div></td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span class="style2">Contract
Period:</span></span></span></span></span></span></span></span></strong></div></
td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span class="style2">Start Date:
</span></span></span></span></span></span></span></span></strong></div></td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span
class="style2">Client:</span></span></span></span></span></span></span></span></
strong></div></td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span
class="style2">Industry:</span></span></span></span></span></span></span></span>
</strong></div></td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1">Form of Contract:
</span></span></span></span></span></span></span></strong></div></td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span
class="style2">Architect:</span></span></span></span></span></span></span></span
></strong></div></td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span class="style2">Structural
Engineer:</span></span></span></span></span></span></span></span></strong></div>
</td>
<td height="20">&nbsp;</td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right"><strong><span class="style2"><span class="style3"><span
class="style3"><span class="style1"><span class="style1"><span
class="style2"><span class="style1"><span class="style2">M &amp; E Engineer:
</span></span></span></span></span></span></span></span></strong></div></td>
<td height="20">&nbsp;</td>
</tr>
</table></td>
<td width="242" rowspan="3" align="left" valign="top"><br>
<table width="100%" height="496" border="0"
cellpadding="0" cel
Reply With Quote
CMBergin
Guest
Posts: n/a
 
Re: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record
Posted: 03-09-2005, 04:19 PM
That's not the line giving the error though.
Normally, the repeat region would prevent such errors. What's the rest of
the code, the part that's truncated?

"Choole" <webforumsuser@macromedia.com> wrote in message
news:d0nanm$1ph$1@forums.macromedia.com...
> That is defo line 75. Here is the code of the page
>
> <%@LANGUAGE="VBSCRIPT"%>
> <!--#include file="../Connections/conn_dmcl.asp" -->
> <%
> Dim rsFact__proj
> rsFact__proj = "%"
> If (request.querystring("project1") <> "") Then
> rsFact__proj = request.querystring("project1")
> End If
> %>
> <%
> Dim rsFact__loc
> rsFact__loc = "%"
> If (request.querystring("location2") <> "") Then
> rsFact__loc = request.querystring("location2")
> End If
> %>
> <%
> Dim rsFact__val
> rsFact__val = "%"
> If (request.querystring("value3") <> "") Then
> rsFact__val = request.querystring("value3")
> End If
> %>
> <%
> Dim rsFact__indust
> rsFact__indust = "%"
> If (request.querystring("industry5") <> "") Then
> rsFact__indust = request.querystring("industry5")
> End If
> %>
> <%
> Dim rsFact__client
> rsFact__client = "%"
> If (request.querystring("client4") <> "") Then
> rsFact__client = request.querystring("client4")
> End If
> %>
> <%
> Dim rsFact
> Dim rsFact_numRows
>
> Set rsFact = Server.CreateObject("ADODB.Recordset")
> rsFact.ActiveConnection = MM_conn_dmcl_STRING
> rsFact.Source = "SELECT * FROM FactQRY WHERE project LIKE '%" +
> Replace(rsFact__proj, "'", "''") + "%' AND location LIKE '%" +
> Replace(rsFact__loc, "'", "''") + "%' AND mclean_value LIKE '%" +
> Replace(rsFact__val, "'", "''") + "%' AND project_type LIKE '%" +
> Replace(rsFact__indust, "'", "''") + "%' AND client_name LIKE '%" +
> Replace(rsFact__client, "'", "''") + "%'"
> rsFact.CursorType = 0
> rsFact.CursorLocation = 2
> rsFact.LockType = 1
> rsFact.Open()
>
> rsFact_numRows = 0
> %>
> <%
> Dim Repeat1__numRows
> Dim Repeat1__index
>
> Repeat1__numRows = 1
> Repeat1__index = 0
> rsFact_numRows = rsFact_numRows + Repeat1__numRows
> %>
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <title>David McLean Contractors Project Fact Sheet</title>
> <style type="text/css">
> <!--
> body {
> margin-left: 0px;
> margin-top: 0px;
> margin-right: 0px;
> margin-bottom: 0px;
> }
> .style1 {color: #FFFFFF}
> .style2 {font-family: Arial, Helvetica, sans-serif}
> .style3 {font-size: 12px}
> .style8 {color: #000000}
> .style9 {
> font-size: 36px;
> font-family: Arial, Helvetica, sans-serif;
> color: #0000CC;
> }
> .style10 {color: #0076bb}
> .style11 {font-family: "Trebuchet MS"}
> .style12 {font-size: 12px; color: #FFFFFF; }
> -->
> </style>
> </head>
>
> <body>
> <table width="100%" height="100%" border="0" cellpadding="0"
cellspacing="0">
> <tr>
> <td height="783" align="center" valign="top"><br>
> <%
> While ((Repeat1__numRows <> 0) AND (NOT rsFact.EOF))
> %>
> <table width="630" height="607" border="0" cellpadding="0"
> cellspacing="0">
> <tr>
> <td align="left" valign="top">&nbsp;</td>
> <td width="626" height="113" colspan="4" align="left"
> valign="top"><table width="100%" border="0" cellspacing="0"
cellpadding="0">
> <tr>
> <td><img src="../images/logo.gif" width="134"
> height="80"></td>
> <td><div align="right"><img src="../images/banner.gif"
> width="447" height="80"></div></td>
> </tr>
> </table></td>
> </tr>
> <tr>
> <td width="4" align="left" valign="top">&nbsp;</td>
> <td colspan="4" align="left" valign="top"><p
class="style9"><span
> class="style10"> <%=(rsFact.Fields.Item("project").Value)%> <br>
> Fact Sheet</span><span class="style3"><br>
> <br>
> </span></p></td>
> </tr>
> <tr>
> <td width="4" align="left" valign="top">&nbsp;</td>
> <td colspan="3" rowspan="3" align="left" valign="top"><table
> width="442" border="0" cellspacing="0" cellpadding="0">
> <tr>
> <td width="442"
> background="../images/Project-Particulars.gif"><div align="center"
> class="style2"><span class="style12">Project Particulars
</span></div></td>
> </tr>
> </table>
> <table width="100%" border="0" cellpadding="0"
cellspacing="0">
> <tr>
> <td width="199" height="515" rowspan="3" align="left"
> valign="top" background="../images/Sidebanner-factsheet.jpg"><br>
> <table width="100%" height="496" border="0"
> cellpadding="0" cellspacing="0">
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style1"><span class="style2"><span
> class="style3"><span
> class="style3">Project:</span></span></span></span></strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span
>
class="style2">Location:</span></span></span></span></span></span></span></s
pan>
> </strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span class="style2">Type of
>
Building:</span></span></span></span></span></span></span></span></strong></
div>
> </td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span class="style2">McLean Value
>
</span></span></span></span></span></span></span></span></strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span class="style2">Contract
>
Period:</span></span></span></span></span></span></span></span></strong></di
v></
> td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span class="style2">Start Date:
>
</span></span></span></span></span></span></span></span></strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span
>
class="style2">Client:</span></span></span></span></span></span></span></spa
n></
> strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span
>
class="style2">Industry:</span></span></span></span></span></span></span></s
pan>
> </strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1">Form of Contract:
> </span></span></span></span></span></span></span></strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span
>
class="style2">Architect:</span></span></span></span></span></span></span></
span
> ></strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span class="style2">Structural
>
Engineer:</span></span></span></span></span></span></span></span></strong></
div>
> </td>
> <td height="20">&nbsp;</td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"><strong><span class="style2"><span class="style3"><span
> class="style3"><span class="style1"><span class="style1"><span
> class="style2"><span class="style1"><span class="style2">M &amp; E
Engineer:
>
</span></span></span></span></span></span></span></span></strong></div></td>
> <td height="20">&nbsp;</td>
> </tr>
> </table></td>
> <td width="242" rowspan="3" align="left"
valign="top"><br>
> <table width="100%" height="496" border="0"
> cellpadding="0" cel

Reply With Quote
 
LinkBack Thread Tools Search this Thread Display Modes
Reply

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot place this file. No filter found for requested operation. Paul Harris Adobe Indesign Macintosh 0 03-05-2006 03:41 AM
how can I print current page livingwithanangel Macromedia Flash Data Integration 0 05-01-2005 12:49 AM
login going to the current url Kamesh192 Macromedia ColdFusion 4 02-17-2005 01:45 PM
Could Not Complete The Requested Operation!! Ahmed_Abbas@adobeforums.com Adobe Illustrator Windows 12 08-03-2004 11:22 PM
How to find a record in a Datagrid with AllowPaging set to true. Jim Mitchell ASP.NET Data Grid Control 0 07-26-2003 01:55 PM