|
Subject:
|
ADODB.Field error '800a0bcd' - FIXED
|
|
Posted By:
|
buddyz
|
Post Date:
|
10/6/2006 2:31:23 PM
|
PLEASE HELP.
I have searched online and worked on this, but I cannot figure it out!
The database record IS THERE AND IT HAS CONTENT, IT DOES EXIST.
How to fix this error?????
COMPLETE ERROR:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/WEBSITE/includes/thestupidfile.asp, line 6
HERE IS LINE 6 AND THE LINES SURROUNDING IT (NOTE - each record can have 3 topics, sometimes the record has 1, sometimes 2 and sometimes 3 topics maximum assigned to it)
<% Function TopicName(item)
Dim iCount
rsTopics.MoveFirst()
iCount = (rsTopics.Fields.Item("ID").Value)
For iCount = (rsTopics.Fields.Item("ID").Value) to 1 step -1
If (item)=(rsTopics.Fields.Item("ID").Value) Then Response.Write(rsTopics.Fields.Item("Topic").Value)
End If
rsTopics.MoveNext()
Next
End Function
Function InvestigatorName(item)
Dim iCount2
For iCount2 = (rsInvestigators.Fields.Item("InvestigatorID").Value) to 1 step -1
THANK YOU for any suggestions you might have to resolve this.
---BuddyZ
|
|
Reply By:
|
dparsons
|
Reply Date:
|
10/6/2006 2:39:36 PM
|
Are you sure that the sql query you *think* your executing is actually the query your executing (read as, have you printed the statement out to the screen to verifiy it)
Are you sure that you have a result set returned to your recordset object?
--Stole this from a moderator
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
|
|
Reply By:
|
buddyz
|
Reply Date:
|
10/9/2006 5:52:04 PM
|
Thanks - I got it. There was an inadvertent omission of a record in the database. I reinstated it, and everything is fine.
Thanks!
Buddy Z
|
