Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › ADODB.Recordset error '800a0bcd' when adding to cart

ADODB.Recordset error '800a0bcd' when adding to cart

Thread began 5/26/2010 9:08 am by russell298997 | Last modified 5/28/2010 1:55 pm by Eric Mittman | 3112 views | 6 replies |

5/26/2010 9:08 am | #1 russell298997

ADODB.Recordset error '800a0bcd' when adding to cart

have cart working fine and adding to cart from a product detail page called productdetail.asp. i set up an identical page called productdetailform.asp so users could search from a dropdown product list box and have the result shown on that page from the FormVariable (productdetail.asp gets its result from querystring).

anyway, works fine until i try to add to cart ewhen i get the following

ADODB.Recordset error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/clients/productdetailform.asp, line 149

have attached the pages - any possibility you could shed light on the error without me sending the whole site etc?

Attached Files

clients.zip

5/26/2010 1:55 pm | #2 Eric Mittman

The productdetailform.asp page is posted to with the id for the item posted as 'search' according to the rsVersionBuy recordset.

The add to cart server behavior is making use of this same rsVersionBuy recordset. From what I can tell when you add to the cart you are submitting the add to cart form, but there is no search form element with the id in it.

So I think that you are not correctly filtering this rsVersionBuy recordset after the add to cart button is submitted. I think that if you added a form element with the name of search and set it to the id of the item it would work correctly. You could do this by copying the ysl_1_ID_Add element that is on line 598 and update the name.

5/27/2010 2:34 am | #3 russell298997

gotcha. thanks eric

5/27/2010 5:17 pm | #4 Eric Mittman

Your welcome, let us know if you have any other questions.

5/28/2010 1:24 am | #5 russell298997

Well there is one thing....

I did put a post question in the Security Assist section that I didnt get a reply to and which I could really really do with sorting out before the weekend - to do with having two log in/authentication behaviours on the same page and them not working. any chance of shedding some light on that one?

thanks as ever

5/28/2010 1:30 am | #6 russell298997

Ignore!

sorry - there was a reply to my other question. apologies

5/28/2010 1:55 pm | #7 Eric Mittman

No problems, I think I responded to that one as well. In my last reply to the thread I gave you some suggestions for consolidating the two logins.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.