BOF/EOF Error that doesn't make sense! Help me!!!!!!!!!!!!

[dennis_halsey]

ASP Code to query access table:

dbPath = Server.mappath("data\allseasons.mdb")
Set site_content_conn = Server.CreateObject("ADODB.Connection")
site_content_conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

SQL4 = "select * FROM oitems where orderitemID=1"
Set RS4 = Server.CreateObject("ADODB.Recordset")
RS4.open SQL4, site_content_conn, 3, 3, 1
orderID=RS4("orderID")
response.write orderID


Error:
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/AllSeason/Development/ASP Code/test.asp, line 116

line 116 says:


Access dabase table:
orderitemID orderID numitems
1 555 5

Feel free to email me: dennis_halsey@charter.net

[Webforumz Staff]

I'd start with changing the SQL statement to

Code: Select all

SQL4 = "select * FROM oitems"

to see if the problem is with the query.

I don't personally use this syntax for opening a recordset

Code: Select all

Set RS4 = Server.CreateObject("ADODB.Recordset") 
RS4.open SQL4, site_content_conn, 3, 3, 1

so maybe someone else will notice if there's a problem with it.

I generally do it with

Code: Select all

set RS4 = site_content_conn.execute(SQL4,,1)

[dennis_halsey]

I tried it the way you recommended and got the same error. Can you give me something that works. I have done this for years and i do not understand what the problem is. It's driving me nuts! I've worked on it for hours! It has to be soemthing simple.

[Rob]

Try doing a compact / repair on the database.

The code Catalyst gave you is correct.

[dennis_halsey]

I tried compact and repair, still same BOF, EOF error, which means no record is being found, correct?

this is strange because i can see the record in the access database, and why it doesn't query it out confuses the hell out of me!

I can use the same code above and query all the fields of another table in the database.

one table i query, it queries some of the fields and not others. I know i spelled field names right, as I copied them straight out of the database and pasted them into the code.


I have used this same queyr for years and why is it not working now?

I don't get it

I can email the database and the code to anyone and let them try to query the data.

Thanks

[Rob]

maybe this is one of those wierd inexplicable errors. try renaming orderitemID to OI_ID in your DB and update your ASP code accordingly.

I had this happen to me once on a field and after rename it worked.... no idea why though.

[dennis_halsey]

changed the field name as you suggested, now getting this error:

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.

Error occurs on this line:
set RS4 = site_content_conn.execute(SQL4,,1)

this is nuts

Can i email the access database and the code to you?

Thnks,

Dennis

[Webforumz Staff]

I only suggest this because I've done it before, but do you have more than one copy of the database on your computer? I've caught myself looking and making changes to a different copy of the file than the website was using.

[JohnMitch]

Have you ever used these same variables before and they work? I got this same message once and it was fixed by changing a variable name.

Your database table does have records in it, doesnt it? Only other time I got this error was cause of this.

[Rob]

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.

This looks like you forgot to change your ASP code to match the renamed database field.