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

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

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)

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.

Try doing a compact / repair on the database.

The code Catalyst gave you is correct.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

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

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.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

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

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.

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.

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

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder