Print Page | Close Window

dynamic.asp error

Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart Standard / PRO / SQL
Forum Description: All questions pertaining to SalesCart Standard, PRO and SQL should be posted here.
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=492
Printed Date: February/05/23 at 11:39am
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com


Topic: dynamic.asp error
Posted By: wesonline
Subject: dynamic.asp error
Date Posted: November/15/05 at 6:29pm
I recently added over 1,ooo products to my products database by an import from MS excell. After the update I have been getting this error when I try and invoke the dynamic.asp page:

ADODB.Recordset error '800a0cc1'

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

E:\0\0\56\708\USER\878\HTDOCS\MALL\../_fpclass/fpdblib.inc, line 190

I researched and found articles 5393 and 5447. I tried both fixes and still get the same error.

Any ideas?



Replies:
Posted By: wesonline
Date Posted: November/16/05 at 10:10am
Found the problem.


Posted By: jkc101
Date Posted: November/16/05 at 3:03pm
Can you give us the fix for future reference?

Thanks!


Posted By: wesonline
Date Posted: November/17/05 at 9:17am
I exported the products database from Access to Excel. I ten input over 1,000 records with all required information. When I imported the information back into Access the ProdID field name changed to ID. I edited the "new" products table fields to match the back-up version. T%hat fixed the problem.

Simple error.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.04 - http://www.webwizforums.com
Copyright ©2001-2015 Web Wiz Ltd. - http://www.webwiz.co.uk