800a0cc1 error

[machman87]

I've recently updated the company webiste where there was a login page
which allowed access to a page where we could update our scrolling
marquee on our home page. This page had a text field with the most
current marquee and all we would do is edit the text to make it say
what we wanted it to say. Yet after I redid the login page, I'd try to
open the update marquee page but I get this 800a0cc1 message. I think
that after I updated everything, the connection names used to verify
the user are different so I changed it so that they would match. But it
still didn't work. Also, when I redid the login page, I added
authorization levels, and I didn't know how to include that in the code
when I tried updating the page. Any help would be appreciated.


Here's the error Message:

ADODB.Fields error '800a0cc1'

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

/update_scroll.asp, line 309

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Here's the code at line 309:


<td width="77%"
class="copybold"><%=(rsUser.Fields.Item("FullName").Value)%> logged
in.</td>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Here's the code in the beginning which declares everything relating to
the database.


<%@LANGUAGE="JAVASCRIPT"%>
<%
// *** Logout the current user.
MM_Logout = String(Request.ServerVariables("URL")) + "?MM_Logoutnow=1";
if (String(Request("MM_Logoutnow"))=="1") {
Session.Contents.Remove("MM_Username");
Session.Contents.Remove("MM_UserAuthorization");
var MM_logoutRedirectPage = "login.asp";
// redirect with URL parameters (remove the "MM_Logoutnow" query
param).
if (MM_logoutRedirectPage == "") MM_logoutRedirectPage =
String(Request.ServerVariables("URL"));
if (String(MM_logoutRedirectPage).indexOf("?") == -1 &&
Request.QueryString != "") {
var MM_newQS = "?";
for (var items=new Enumerator(Request.QueryString); !items.atEnd();
items.moveNext()) {
if (String(items.item()) != "MM_Logoutnow") {
if (MM_newQS.length > 1) MM_newQS += "&";
MM_newQS += items.item() + "=" +
Server.URLencode(Request.QueryString(items.item()));
}
}
if (MM_newQS.length > 1) MM_logoutRedirectPage += MM_newQS;
}
Response.Redirect(MM_logoutRedirectPage);
}
%>
<!--#include file="Connections/connLiftoff.asp" -->
<%
// *** Restrict Access To Page: Grant or deny access to this page
var MM_authorizedUsers="corp";
var MM_authFailedURL="menu.asp";
var MM_grantAccess=false;
if (String(Session("MM_Username")) != "undefined") {
if (false || (String(Session("MM_UserAuthorization"))=="") ||
(MM_authorizedUsers.indexOf(String(Session("MM_UserAuthorization")))

=0)) {

MM_grantAccess = true;
}
}
if (!MM_grantAccess) {
var MM_qsChar = "?";
if (MM_authFailedURL.indexOf("?") >= 0) MM_qsChar = "&";
var MM_referrer = Request.ServerVariables("URL");
if (String(Request.QueryString()).length > 0) MM_referrer =
MM_referrer + "?" + String(Request.QueryString());
MM_authFailedURL = MM_authFailedURL + MM_qsChar + "accessdenied=" +
Server.URLEncode(MM_referrer);
Response.Redirect(MM_authFailedURL);
}

Any help would be greatly appreciated.