Finding an eCart value
I need to filter an update query with an eCart column value.
I'm using a while statement to poll a table of books; one of the eCart columns is the recID for any book in the cart. I need to update the purchaseDate field for any book whose recID is in the cart.
Is there a clean way to just try and match the recID values in the cart in an UPDATE statement??