Ado Error 0x800a0bcd
- ASP Hi! I have a ASP page that generates an excel report. It works fine if there are records found, however, if no records are found I would like to call the below listed function instead of getting the following error that I am presently receiving: Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record ' Move to the first record rs.movefirst <------- Errors here if rs.eof then 'new code ' Start a loop that will end with the last record do while not rs.eof ... ' ... Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode October 21st,04:16 PM #1 Error Type: ADODB.Recordset (0x800A0BCD) Hi! I have a ASP page that generates an excel report. It works fine if there are records found, however, if no records are found I would like to call the below listed function instead of getting the following error that I am presently receiving: Error Type: ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record ' Move to the first record rs.movefirst <------- Errors here if rs.eof then 'new code ' Start a loop that will end with the last record do while not rs.eof ... ' Move to the next record rs.movenext ' Loop back to the do statement loop else 'new code call norecordsfound() 'new code end if 'new code %> Thank you in advance. Chuck Chuck Guest October 21st,04:22 PM #2 Re: Error Type: ADODB.Recordset (0x800A0BCD) You don't need to use rs.Movefirst anyway, since it'll start at the beginning. But, your issue is that there are no records in your recordset. If Not rs.EOF Then '''your looping code Else response.write "There are no records." End If Ray at work "Chuck"
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/General ASP.NET/Getting Started/Either BOF or EOF is True, or the current record has been deleted. Re... Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. [Answered]RSS 7 replies Last post Aug 14, 2007 01:49 PM by jenpitts ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply jenpitts None http://www.justskins.com/forums/error-type-adodb-recordset-145250.html 0 Points 4 Posts Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a... Aug 14, 2007 11:25 AM|jenpitts|LINK Can someone tell me what I have wrong in this code? The error is below the code: Code: If request.form("b4") = "Next Page" then Set objConn = ficpa.getNetLinkDBConnection() http://forums.asp.net/t/1146303.aspx?Either+BOF+or+EOF+is+True+or+the+current+record+has+been+deleted+Requested+operation+requires+a+current+record+ strSQL = "SELECT * FROM chapmeetreq2 WHERE chapter = '" & session("chap") & "' and entrydate = '" & date() & "' order by req_id desc" strSQL = "SELECT * FROM chapmeetreq2 inner JOIN chapmeetreq2ev ON chapmeetreq2.req_id = chapmeetreq2ev.req_id WHERE (chapmeetreq2.chapter = '" & session("chap") & "') AND (chapmeetreq2.entrydate = '" & date() & "') ORDER BY chapmeetreq2.req_id DESC" set objRS2 = Server.CreateObject("ADODB.Recordset") objRS2.Open strSQL, objConn, 3, 3 req_id = objrs2("req_id") session("req_id") = req_id req_id = objrs2("req_id") if request.form("eventsev") <> "" then objRS2.fields("eventsev") = request.form("eventsev") else objRS2.fields("eventsev") = "" end if objRS2.Update objRS2.Close objrs.close set objrs2= nothing Set objRS = Nothing response.redirect("/ficpa/members/chapters/toolkit/chaptermeetingnotice2/page5") end if %> Error: Error report Error in document ficpa\Members\Chapters\Toolkit\ChapterMeetingNotice2\page4 Category: Script Description: Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. Error code: 0x800a0bcd Unknown error 0x
details. I am not able to open http://www.bigresource.com/ASP-ASP-error-ADODB-Field-0x800A0BCD--bdcFRZwp.html the page, I am getting an error.
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: ADODB.Field (0x800A0BCD) - HELP!! Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-04-2006,11:32 AM #1 tirion_angel View Profile View Forum Posts Registered User Join Date Jul 2006 Posts 16 ADODB.Field (0x800A0BCD) - HELP!! Okay, so here is my error: ADODB.Field (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. I have no idea how to fix this, so any suggestions would be great! And below, my code: <%@ Language=VBScript %> <% Option Explicit 'Response.ContentType = "application/vnd.ms-word" 'Response.AddHeader "content-disposition", "inline; filename=pmaform.doc" strversion = Request.QueryString("version") strapprover = Request.QueryString("Approved_by") strmigrator = Request.QueryString("Migrated_by") %>