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

Choole · Choole

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

CMBergin · CMBergin

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
>

Choole · Choole

That is defo line 75. Here is the code of the page

<%@LANGUAGE="VBSCRIPT"%>

<%
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">

</style>
</head>

<body>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="783" align="center" valign="top"> 
<%
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"> </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"> </td>
<td colspan="4" align="left" valign="top"> <%=(rsFact.Fields.Item("project").Value)%> 
Fact Sheet 
 
</td>
</tr>
<tr>
<td width="4" align="left" valign="top"> </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">Project Particulars </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"> 
<table width="100%" height="496" border="0"
cellpadding="0" cellspacing="0">
<tr>
<td height="20" valign="top"><div
align="right">Project:</div></td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Location:
</div></td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Type of
Building:</div>
</td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">McLean Value
</div></td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Contract
Period:</div></
td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Start Date:
</div></td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Client:</div></td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Industry:
</div></td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Form of Contract:
</div></td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Architect:</span

></div></td>

<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">Structural
Engineer:</div>
</td>
<td height="20"> </td>
</tr>
<tr>
<td height="20" valign="top"><div
align="right">M & E Engineer:
</div></td>
<td height="20"> </td>
</tr>
</table></td>
<td width="242" rowspan="3" align="left" valign="top"> 
<table width="100%" height="496" border="0"
cellpadding="0" cel

CMBergin · CMBergin

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"%>
> 
> <%
> 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">
> 
> </style>
> </head>
>
> <body>
> <table width="100%" height="100%" border="0" cellpadding="0"

cellspacing="0">

> <tr>
> <td height="783" align="center" valign="top"> 
> <%
> 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"> </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"> </td>
> <td colspan="4" align="left" valign="top"><p

class="style9"><span

> class="style10"> <%=(rsFact.Fields.Item("project").Value)%> 
> Fact Sheet 
> 
> </td>
> </tr>
> <tr>
> <td width="4" align="left" valign="top"> </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">Project Particulars

</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"> 
> <table width="100%" height="496" border="0"
> cellpadding="0" cellspacing="0">
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style3">Project:</div></td>
> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">

class="style2">Location:</s
pan>

> </div></td>
> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">Type of
>

Building:</
div>

> </td>
> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">McLean Value
>

</div></td>

> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">Contract
>

Period:</di
v></

> td>
> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">Start Date:
>

</div></td>

> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">

class="style2">Client:</spa
n></

> strong></div></td>
> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">

class="style2">Industry:</s
pan>

> </div></td>
> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">Form of Contract:
> </div></td>
> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">

class="style2">Architect:</
span

> ></div></td>

> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">Structural
>

Engineer:</
div>

> </td>
> <td height="20"> </td>
> </tr>
> <tr>
> <td height="20" valign="top"><div
> align="right"> class="style3"> class="style2">M & E

Engineer:

>

</div></td>

> <td height="20"> </td>
> </tr>
> </table></td>
> <td width="242" rowspan="3" align="left"

valign="top">

> <table width="100%" height="496" border="0"
> cellpadding="0" cel

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

Thread Tools

Display

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

Similar Questions and Discussions

value list with unique options by current record

Query to insert into current record

Augh! EOF/BOF/non-current record

Send current record data in one form to another and print?

accessing current written record

Re: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record

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

Re: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record

Posting Permissions