Web Wiz Support and Community Forums : ADODB.Recordset error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 11:30:31 +0000 Wed, 14 Jan 2004 10:15:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=8869 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[ADODB.Recordset error : Thanks for that. I must be having...]]> https://forums.webwiz.net/adodb-recordset-error_topic8869_post46843.html#46843 Author: wgbeatty
Subject: 8869
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

]]> Wed, 14 Jan 2004 10:15:09 +0000 https://forums.webwiz.net/adodb-recordset-error_topic8869_post46843.html#46843 <![CDATA[ADODB.Recordset error : This is a problem with the stored...]]> https://forums.webwiz.net/adodb-recordset-error_topic8869_post46798.html#46798 Author: WebWiz-Bruce
Subject: 8869
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.
]]> Wed, 14 Jan 2004 06:01:48 +0000 https://forums.webwiz.net/adodb-recordset-error_topic8869_post46798.html#46798 <![CDATA[ADODB.Recordset error : Hmm. Removed the offending line...]]> https://forums.webwiz.net/adodb-recordset-error_topic8869_post46733.html#46733 Author: wgbeatty
Subject: 8869
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

]]> Tue, 13 Jan 2004 21:35:34 +0000 https://forums.webwiz.net/adodb-recordset-error_topic8869_post46733.html#46733 <![CDATA[ADODB.Recordset error : Hey all, Just encountered this...]]> https://forums.webwiz.net/adodb-recordset-error_topic8869_post46715.html#46715 Author: wgbeatty
Subject: 8869
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



Edited by wgbeatty]]> Tue, 13 Jan 2004 18:15:45 +0000 https://forums.webwiz.net/adodb-recordset-error_topic8869_post46715.html#46715