ADODB.Recordset error '800a0cc1'
dmitri kerievsky
attached. I open two instances of the asp page. I click the
will attend button on the first page, and then on the second. the first page
shows one person in the grid, and the second page
shows two, because it happened later. I then click will not attend on the
first page, and the first person is removed form the
grid, while the second person shows up. I then go to the second page and
remove that person from the grid by clicking "will not attend button" - both
names are removed from the grid. I go back to the first page, and click
"will attend" and receive the error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name
or ordinal.
/readinggroup/_ScriptLibrary/Recordset.ASP, line 840
does Q190589 have anything to do with this? I looked at it, but can't tell
if it addresses the issue.
thanks
here is the code:
Sub btnWillNotAttend_onclick()
'BUTTON CALLED UNCONFIRM
if trim(btnWillNotAttend.value)="will not attend" then
NameList2
Set DE = Server.CreateObject("DERuntime.DERuntime")
DE.Init(Application("DE"))
DE.Unconfirm
txtfirstname.value,txtlastname.value,Recordset2.fields.getvalue(4)
Set objCMD = DE.Commands("Unconfirm")
RetVal = objCMD.Parameters(0)
if RetVal=1 or RetVal=2 then
Response.Write "<BODY onLoad=""window.alert('This latest book must be
chosen and the guest must be confirmed before they unconfirm.')"">"
exit sub
end if
Recordset2.requery
Recordset4.requery
Response.Clear
end if
End Sub
Sub btnWillAttend_onclick()
'BUTTON CALLED CONFIRM
Response.Write " 000 :" & now()
if trim(btnWillAttend.value)="will attend w/note" then
Response.Write " 00 :" & now()
Namelist2
'exit sub
Response.Write " 0 :" & now()
Set DE = Server.CreateObject("DERuntime.DERuntime")
DE.Init(Application("DE"))
DE.WillAttend
Recordset2.fields.getvalue(4),txtcomment.value,txtfirstname.value,txtlastnam
e.value
Set objCMD = DE.Commands("WillAttend")
RetVal = objCMD.Parameters(0)
'if RetVal=1 then
' Response.Write "<BODY onLoad=""window.alert('An club date must first be
entered.')"">"
'Response.Write "<BODY onLoad=""window.confirm('EEWREW')"">"
' exit sub
'end if
Response.Write " 1 : " & now()
txtcomment.value=""
Recordset2.requery
Recordset4.close
Session("Criteria")=txtlatestmeetingdate.value
Recordset4.open()
'Recordset4.requery
Set DE = Server.CreateObject("DERuntime.DERuntime")
DE.Init(Application("DE"))
DE.Comments txtlatestmeetingdate.value
Set objCMD = DE.Commands("Comments")
RetVal = objCMD.Parameters(0)
if RetVal=1 then
Response.Write " 2 :" & now()
Grid2.show()
Recordset4.close
Session("Criteria")=txtlatestmeetingdate.value
Recordset4.open()
Response.Flush
Response.Clear
exit sub
else
Response.Write "<BODY onLoad=""window.alert('There are no notes for this
book.')"">"
Grid2.hide()
end if
Response.Flush
Response.Clear
'Response.End
end if
End Sub
"Aaron Bertrand [MVP]" <aaronATaspfaq.com> wrote in message
news:eqrs9N4HCHA.2472@tkmsftngp11...
> It means you referred to a column name or ordinal position that doesn't
> exist. If you show your code, it will probably be easy to spot. This is
> usually because you say something like
>
> SELECT COUNT(column) FROM table
>
> And then attempt to reference it as
>
> rs("column") or rs("COUNT(column)")
>
> http://www.aspfaq.com/show.asp?id=2159
> http://www.aspfaq.com/show.asp?id=2038
> http://www.aspfaq.com/show.asp?id=2275
>
>
>
>
> "dmitri kerievsky" <dmi...@mindspring.com> wrote in message
> news:afk39v$r0h$1...@slb2.atl.mindspring.net...
> > ADODB.Recordset error '800a0cc1'
> >
> > Item cannot be found in the collection corresponding to the requested
name
> > or ordinal.
> >
> > /readinggroup/_ScriptLibrary/Recordset.ASP, line 840
> >
> >
> > any idea what this error indicates or how to resolve it?
> > tia,
> > dmitri
> >
> >
> >
>
>
Tex String
"dmitri kerievsky" <dmi...@mindspring.com> wrote in message news:afn93f$d3o$1...@slb7.atl.mindspring.net...
dmitri kerievsky
see an instance in
my code where it was occurring. Is that possible? I can include the code.
Have you seen this
error before?
tia,
dk
"Tex String" <m...@overthere.com> wrote in message
news:OjoC9DHICHA.2480@tkmsftngp11...
Tex String
"dmitri kerievsky" <dmi...@mindspring.com> wrote in message news:afq20v$7nm$1...@slb6.atl.mindspring.net...
> After looking at the http://www.adopenstatic.com/faq/800a0cc1.asp I did not
> see an instance in
> my code where it was occurring. Is that possible? I can include the code.
> Have you seen this
> error before?
> tia,
> dk
looks like your using the Visual Studio Controls, I never had much luck with them, if you look in your IIS documentation it tells
you how to do it all manualy, not hard, has examples