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.
Printed Date: February/29/24 at 6:18am
Software Version: Web Wiz Forums 11.04 -

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/, line 190

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

Any ideas?

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?


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 -
Copyright ©2001-2015 Web Wiz Ltd. -