ADODB.Field error ' 800a0bcd', Either BOF

Results 1 to 2 of 2

Thread: ADODB.Field error ' 800a0bcd', Either BOF

  1. #1
    Join Date
    Dec 1969

    Default ADODB.Field error ' 800a0bcd', Either BOF

    Can you help please!<BR><BR>This error has occured when the records do exisit as they are shown on the previous page. I have recently upgraded to office 2000 and had to covert the access database to 2000 version. Does this have anything to do with this problem? It happens on some records not all of them.<BR><BR>Error Message: <BR><BR>ADODB.Field error &#039 800a0bcd&#039 <BR><BR>Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record. <BR><BR>/newharwin2/shopping/carts/check_out.asp, line 24 <BR><BR>(Line 24 marked by ****)<BR><BR><BR>&#060;%<BR>iCount = Session("ItemCount")<BR>shoppingcart = Session("MyShoppingCart")<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR> <BR>If Request.QueryString("ProductCode") &#060;&#062; "" Then<BR> If iCount &#060; MaxShoppingCartItems Then<BR> iCount = iCount + 1<BR> End if<BR> Session("ItemCount") = iCount<BR> Conn.Open Session("ConnectionString")<BR><BR> SQLcatalog_item = "SELECT * FROM Pricing WHERE {fn UCASE(Partnumber)} = &#039" & Ucase(Request.QueryString("ProductCode")) & "&#039"<BR><BR> Set RS = Conn.Execute(SQLcatalog_item)<BR><BR> <BR> shoppingcart(cartCHECKED,iCount) = "CHECKED"<BR> **** shoppingcart(cartProductCode,iCount) = RS("Partnumber")<BR> shoppingcart(cartProductName,iCount) = RS("familynumber")<BR> shoppingcart(cartProductDescription,iCount) = RS("UOM")<BR> shoppingcart(cartItemQuantity,iCount) = abs(CLng(request("quantity")))<BR><BR> <BR>End If<BR><BR><BR>Hope you can help?<BR><BR>Thanks<BR><BR>Nicky

  2. #2
    Join Date
    Dec 1969

    Default RE: ADODB.Field error ' 800a0bcd', Either

    Use &#060;%=Request("ProductCode")%&#062; to see if something is being passed- if its empty thats why youre getting the error message.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts