I thought I was done and everything was working but then I realized that I used the Store Cart Details in Database Server Behaviors instead of the DataAssist insert behavior. Everything was working great except that when you log in at a different time, like one would expect a customer to do using a wishlist, the Store Cart Details in Database Server Behavior deleted the old info that was in the table and creates a whole new cart, something that will not work for a wishlist.
The problem I am having now is that the DataAssist insert behavior stores the correct UserID but not the correct ProductID and Quantity. I have tried binding it to the Recordset, to all the carts etc but nothing seems to work using DataAssist insert behavior. The Store Cart Details in Database Server Behavior worked brilliantly but if the items keep on getting deleted it is of no use to me. Is there a way that the Store Cart Details in Database Server Behavior coding can be changed to not delete the previous cart items stored in the database?
Any ideas on what can be wrong? I attached a copy of the page I am working on, maybe you can see my problem.