Web Wiz Forums - ADODB.Recordset error

Print Page | Close Window

ADODB.Recordset error

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8869
Printed Date: 07 April 2026 at 11:29am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ADODB.Recordset error

Posted By: wgbeatty
Subject: ADODB.Recordset error
Date Posted: 13 January 2004 at 6:15pm

Hey all,

Just encountered this error while trying to view a forum with posts:

ADODB.Recordset error '800a0cc1'

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

/forum/forum_topics.asp, line 424

This is the code around that line number:

'Read in the subject and author and number of replies from the record set
   strTopicStartUsername = rsTopic("Username")
   strFirstPostMsg = Mid(rsTopic("Message"), 1, 275)
   lngTopicStartUserID = CLng(rsTopic("Author_ID"))
   lngNumberOfReplies = CLng((rsTopic.RecordCount) - 1)
   dtmFirstEntryDate = CDate(rsTopic("Message_date"))

Apparently, it's this line:
strFirstPostMsg = Mid(rsTopic("Message"), 1, 275)

Any ideas? I just did a fresh install of 7.7 today for SQL Server and hadn't noticed any other problems until I posted in a forum, then tried viewing that forum to see the post.

Warren

Replies:

Posted By: wgbeatty
Date Posted: 13 January 2004 at 9:35pm

Hmm.

Removed the offending line for kicks, and somehow it worked. I was able to view posts in all forums. Strange - strange to me cause I'm not exactly sure what's going on. I do alot of guess work, and pretty much have a basic knowledge at that of VB/ASP/SQL etc.

If anyone has any ideas I'm all ears (or eyes).

Regards,

Warren

Posted By: WebWiz-Bruce
Date Posted: 14 January 2004 at 6:01am

This is a problem with the stored procedures not returning all the correct fields.

If you are updating from a previous version check old upgrade posts for the correct stored procedure.

If this is a clean install, start again and delete the database and stored procedures and run the setup file.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wgbeatty
Date Posted: 14 January 2004 at 10:15am

Thanks for that. I must be having upload problems from here, cause I did wipe everything out and then run the setup file. I'll investigate today and see if all the correct SP's are there.

Warren