currency switcher

Dear Webassist,
I am wanting to add a currency switcher to my ecart installation. I am storing the cart as a cookie and would like to be able to do something like when a user changes the currency on a form to loop through the carts contents and update the Price to a new price from a DB table, then repackage the cart cookie with the updated prices. I assume I can use the function UpdateCart(), but I am unclear as to how this function works.

The new currency prices are held in a DB table. Is is possible to run a loop and update all items prices to the new currency? And does UpdateCart() rebuild the cookie once it is updated? Or is there a better way to do this using the built in ecart function?

How would you suggest I do this.

on changing the currency, you would need to loop through the cart and save all the item ids to a comma separated list.

clear the cart

create a recordset to return the items that had been in the cart using the coma separated list:

SELECT * FROM Products WHERE ProductID IN (<comma separated list>)

then use the populate cart from recordset behavior to repopulate the cart with the correct currency. It will take some hand coding top accomplish this.

Thank you Jason, that worked perfectly and so much simply that the way I was trying to do it. Thank you so much for your suggestion.

You're welcome, glad to hear it is working.