I have the following SQL action set up for a plan:However this does not execute when assigning the plan from the backend (it also works fine in PHPMyAdmin when replacing [user_id]).

Am I missing something here? Should this not work?

On a related note, what I am doing is adding an additional selection to a (read-only) multi-checkbox field. Ideally the CB Fields plugin would have an additional "Operator" something like "Append: Field = Field |*| Value" which would do what my UPDATE statement is doing. Then I wouldn't need to use an SQL action.

Many thanks in advance

I forgot to mention I am using J v1.5.22, CB v1.4 and CBSubs v1.1.2.

Many thanks

I see, that makes sense, thanks for you response.

Would you also consider adding the Append option to the CB Fields Operator so that additional multi-select values can be added (rather then overwritten) when subscribing to a plan. This would remove the need for using the SQL Action in this example.

Many thanks

You are (very nearly) right. After further testing, any multi-select field value does actually get appended automatically with the correct separator (where as normal fields just get overwritten). It doesn't need the "|*|" as that is added automatically so adding "|*|Value" results in "|*||*|Value" in the database meaning you just need "Value"

This is excellent and makes a lot of sense. Thank you for such intelligent software (although I couldn't find this feature documented anywhere).