error message online retrieval plug-in

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello

I am getting an error message every time I try to retrieval valid data (ex: an order number or range of numbers I know to exist).

ADODB.Recordset error '800a0cc1' 

Item cannot be found in the collection corresponding to the requested name or ordinal. 

C:\WEBSITES\QUINCYADULTED\ONLINE\../_fpclass/fpdblib.inc, line 48

I read a couple of previous posts regarding similar problems, but the solutions were not clear.  Something about a space in the data name.  Where does this space go?

The odd thing is that if I request bogus information (an incorrect date - say 2006 or an order number which does not exist) the database correctly returns a "no records found"

Go figure...

Can anyone help with this??

Thanks in advance.

Pat Browne

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
phbrowne Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: March/31/04 Location: United States Status: Offline Points: 16	Post Options Post Reply Quote phbrowne Report Post Thanks(0) Quote Reply Topic: error message online retrieval plug-in Posted: August/19/05 at 8:56am
	Hello I am getting an error message every time I try to retrieval valid data (ex: an order number or range of numbers I know to exist). ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the requested name or ordinal. C:\WEBSITES\QUINCYADULTED\ONLINE\../_fpclass/fpdblib.inc, line 48 I read a couple of previous posts regarding similar problems, but the solutions were not clear. Something about a space in the data name. Where does this space go? The odd thing is that if I request bogus information (an incorrect date - say 2006 or an order number which does not exist) the database correctly returns a "no records found" Go figure... Can anyone help with this?? Thanks in advance. Pat Browne

Techno Geek Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Evil monkey living in my closet! Joined: March/11/04 Location: United States Status: Offline Points: 1206	Post Options Post Reply Quote Techno Geek Report Post Thanks(0) Quote Reply Posted: August/19/05 at 9:16am
	Hmm. That is a strange one. The one thing I notice is that it is referring to ../_fpclass/fpdblib.inc perhaps that's the issue here. Have you tried re-installing the order management? Have you also tried re-creating the "database1" connection string?
	Techno Geek Customer Support Engineer ComCity and SalesCart Technical Support

phbrowne Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: March/31/04 Location: United States Status: Offline Points: 16	Post Options Post Reply Quote phbrowne Report Post Thanks(0) Quote Reply Posted: August/19/05 at 10:22am
	um...it's been awhile. How do I reinstall the order processing plug in? Just reload the web pages?

phbrowne Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: March/31/04 Location: United States Status: Offline Points: 16	Post Options Post Reply Quote phbrowne Report Post Thanks(0) Quote Reply Posted: August/22/05 at 9:59am
	How do I reload the order processing module?

Techno Geek Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Evil monkey living in my closet! Joined: March/11/04 Location: United States Status: Offline Points: 1206	Post Options Post Reply Quote Techno Geek Report Post Thanks(0) Quote Reply Posted: August/22/05 at 12:19pm
	Go to the SC Toolbar, click on the first icon, then look for [SalesCart] Order Management option.
	Techno Geek Customer Support Engineer ComCity and SalesCart Technical Support