dont update record field if session blank
Good morning,
I am trying to figure out how to acheive the following.
I have billing and shipping address sessions set during checkout.
After checkout, I would like to update the user record with session values.
This I have acheived.
However, if during checkout the billing address is left blank (therefore session is blank), when the update runs, it blanks out the billing address record. (as you'd expect.)
Is there a way to use the update behaviour, so that if the session value is set, but blank, the update will not overwrite what is already held in the database field?
It's got my mind bending. And I can't think of a neat solution.
Any help would be appreciated.
Thanks,
Ben