SalesCart Standard / PRO / SQL

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: November/23/24 at 3:35pm
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.