Error Code 800a0cc1 mean? 1

[cctrinh]

I got the following error code and don't know what it mean? Can someone help please? Thank you

ADODB.Recordset error '800a0cc1'

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

/ASPTest/User.asp, line 21

 

[jemminger]

Usually means you're asking for a column name that doesn't exist, or you've misspelled a column name when trying to write to the page...

This can happen if your query is "SELECT column1,column2 FROM myTable"

but then use:
Response.Write(objRS("col2&quot)

 

[Jonax]

Jemminger is right:
compare the column-names in your SQL-string to the names in your DB! This is not a bug - it's an undocumented feature...
;-)