Forum Home Forum Home > Legacy Products > SalesCart Standard / PRO / SQL
  New Posts New Posts RSS Feed - dynamic.asp error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum Lockeddynamic.asp error

 Post Reply Post Reply
Author
Message
wesonline View Drop Down
Newbie
Newbie
Avatar

Joined: August/25/04
Location: United States
Status: Offline
Points: 23
Post Options Post Options   Thanks (0) Thanks(0)   Quote wesonline Quote  Post ReplyReply Direct Link To This Post Topic: dynamic.asp error
    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?
Back to Top
wesonline View Drop Down
Newbie
Newbie
Avatar

Joined: August/25/04
Location: United States
Status: Offline
Points: 23
Post Options Post Options   Thanks (0) Thanks(0)   Quote wesonline Quote  Post ReplyReply Direct Link To This Post Posted: November/16/05 at 10:10am
Found the problem.
Back to Top
jkc101 View Drop Down
Newbie
Newbie
Avatar

Joined: July/08/05
Location: United States
Status: Offline
Points: 26
Post Options Post Options   Thanks (0) Thanks(0)   Quote jkc101 Quote  Post ReplyReply Direct Link To This Post Posted: November/16/05 at 3:03pm
Can you give us the fix for future reference?

Thanks!
Back to Top
wesonline View Drop Down
Newbie
Newbie
Avatar

Joined: August/25/04
Location: United States
Status: Offline
Points: 23
Post Options Post Options   Thanks (0) Thanks(0)   Quote wesonline Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.04
Copyright ©2001-2015 Web Wiz Ltd.

Copyright 2015 by ComCity® LLC and SalesCart™.  All Rights Reserved