Either BOF or EOF is True error makes absolutely no sense

[Chumley the Walrus]

When i put an explicit value in the sql statement below as
"displaygroup =1 ",
i do see my records (or my response.write test after the recordset
Open line) appear on my dynamic page. But when use code below and
match the 'displaygroup'
field with my dp variable (which was assigned in a prior recordset/sql
block) :

<%dim cm,dp
dp = rs("displaygroup")

%>
<% dim rs2,strSQLd2,ii
Set rs2 = Server.CreateObject ("ADODB.Recordset")
strSQLd2 = "Select productname,productprice from products where
displaygroup = " & dp & ""
rs2.Open strSQLd2, dbc
response.write dp %>
....i get the "Either BOF or EOF is true, or record has been deleted"
error, when i know for a fact (since my explicit displaygroup =1 , or
=2 works) there are records that match that criteria.

Thanks for your help
Chumley

[Steven Burn]

This error has been bugging me for over a year (never found the cause of it,
as it appears to show, as you've said, even when the record exists). If you
find the answer, I'd be grateful if you could pass it on.

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
Chumley the Walrus <sp*******@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...

When i put an explicit value in the sql statement below as
"displaygroup =1 ",
i do see my records (or my response.write test after the recordset
Open line) appear on my dynamic page. But when use code below and
match the 'displaygroup'
field with my dp variable (which was assigned in a prior recordset/sql
block) :

<%dim cm,dp
dp = rs("displaygroup")

%>
<% dim rs2,strSQLd2,ii
Set rs2 = Server.CreateObject ("ADODB.Recordset")
strSQLd2 = "Select productname,productprice from products where
displaygroup = " & dp & ""
rs2.Open strSQLd2, dbc
response.write dp %>
...i get the "Either BOF or EOF is true, or record has been deleted"
error, when i know for a fact (since my explicit displaygroup =1 , or
=2 works) there are records that match that criteria.

Thanks for your help
Chumley

[Ray at]

You need to know what the value of dp is instead of assuming that it's a
valid value for your query.

dp = rs("displaygroup")
Response.Write "dp is " & dp
RESPONSE.END

Ray at work

"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...

When i put an explicit value in the sql statement below as
"displaygroup =1 ",
i do see my records (or my response.write test after the recordset
Open line) appear on my dynamic page. But when use code below and
match the 'displaygroup'
field with my dp variable (which was assigned in a prior recordset/sql
block) :

<%dim cm,dp
dp = rs("displaygroup")

%>
<% dim rs2,strSQLd2,ii
Set rs2 = Server.CreateObject ("ADODB.Recordset")
strSQLd2 = "Select productname,productprice from products where
displaygroup = " & dp & ""
rs2.Open strSQLd2, dbc
response.write dp %>
...i get the "Either BOF or EOF is true, or record has been deleted"
error, when i know for a fact (since my explicit displaygroup =1 , or
=2 works) there are records that match that criteria.

Thanks for your help
Chumley

[Kris Eiben]

Which line is getting the error?

Above: rs2.open strSQLd2, dbc
try: response.write strSQLd2
That will show you the problem immediately, if dp is not getting set, or
getting set to something you don't expect..

Also, you don't need that empty & "" at the end of the query. Try
taking it out.

"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...

When i put an explicit value in the sql statement below as
"displaygroup =1 ",
i do see my records (or my response.write test after the recordset
Open line) appear on my dynamic page. But when use code below and
match the 'displaygroup'
field with my dp variable (which was assigned in a prior recordset/sql
block) :

<%dim cm,dp
dp = rs("displaygroup")

%>
<% dim rs2,strSQLd2,ii
Set rs2 = Server.CreateObject ("ADODB.Recordset")
strSQLd2 = "Select productname,productprice from products where
displaygroup = " & dp & ""
rs2.Open strSQLd2, dbc
response.write dp %>
...i get the "Either BOF or EOF is true, or record has been deleted"
error, when i know for a fact (since my explicit displaygroup =1 , or
=2 works) there are records that match that criteria.

[Chris Barber]

Make sure that it's not attempting to match numeric with string (or even
worse a char() field that is buffered with spaces).

Q. Is displaygroup a numeric field or a textual field?

For debugging make sure you write the querystring to the browser and then
use it in the QueryAnalyzer to see if the query statement is correct.

Chris.

"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...
When i put an explicit value in the sql statement below as
"displaygroup =1 ",
i do see my records (or my response.write test after the recordset
Open line) appear on my dynamic page. But when use code below and
match the 'displaygroup'
field with my dp variable (which was assigned in a prior recordset/sql
block) :

<%dim cm,dp
dp = rs("displaygroup")

%>
<% dim rs2,strSQLd2,ii
Set rs2 = Server.CreateObject ("ADODB.Recordset")
strSQLd2 = "Select productname,productprice from products where
displaygroup = " & dp & ""
rs2.Open strSQLd2, dbc
response.write dp %>
....i get the "Either BOF or EOF is true, or record has been deleted"
error, when i know for a fact (since my explicit displaygroup =1 , or
=2 works) there are records that match that criteria.

Thanks for your help
Chumley

[Dave Anderson]

"Chumley the Walrus" wrote:

dp = rs("displaygroup")

...

Set rs2 = Server.CreateObject ("ADODB.Recordset")
strSQLd2 = "Select productname,productprice from products where
displaygroup = " & dp & ""
rs2.Open strSQLd2, dbc
response.write dp %>

You want the VALUE assigned your variable, not the OBJECT. A much better
practice is to be explicit:

dp = rs.Fields("displaygroup").Value

String concatenation makes a whole lot more sense with values than with
objects. And those values never have EOF/BOF conditions.

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.