homepage Welcome to WebmasterWorld Guest from 54.198.94.76
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
ADODB.Field error '80020009'
client gets this message, I see the page fine
htdawg




msg:4283202
 7:00 pm on Mar 17, 2011 (gmt 0)

Hi,
I have a weird problem, my client cant see a page on his website and gets this message when he tries to open a page

now on my computer I can see the page just fine.
from what I understand this error means that the record 9in this case a product that is listed on his site does not exist)

could this be browser related problem? he tried i.e & firefox.


There were no records found. Try another search...

ADODB.Field error '80020009'

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

/sailingdetails.asp, line 0

 

defanjos




msg:4283222
 7:35 pm on Mar 17, 2011 (gmt 0)

Could he be looking at a product that no longer exists or is not active, and you are looking at one that exists?

For example,

he tries:
../sailingdetails.asp?ID=123
(123 does not exist)

you try:
../sailingdetails.asp?ID=234
(234 exists)

If you are looking at the same page, then that is weird. I cannot see a caching issue causing that.

htdawg




msg:4283228
 7:45 pm on Mar 17, 2011 (gmt 0)

the page /sailingdetails.asp?ID=123 opens for me just fine
I can see the product but on his computer he cant, he just gets the error code.

defanjos




msg:4283242
 8:01 pm on Mar 17, 2011 (gmt 0)

You are accessing the page via the web, and not locally in your computer, correct?

To be absolutely sure you are both looking at the same page, email the link to him and yourself, you click on it, and he clicks on it - do you still have the same problem?

Just for the heck of it, I would ask him to delete his browser cache.

htdawg




msg:4283271
 8:32 pm on Mar 17, 2011 (gmt 0)

I can seethe page online, so I'll tell hime to clear his browser cache and see what happens, i think he might have a problem with his pc/browser. i tried opening the page on to computers and it was ok.

bmcgee




msg:4284694
 6:30 pm on Mar 20, 2011 (gmt 0)

It is a server side error, so the problem is not "on his machine" per se. It could be a caching issue that has "gone away" now, but the root of the problem is that your code is not properly handling the situation of the query returning no results.

You need to fix that before you start worrying about his cache.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved