Trying to use a simple SQL statement to update affiliate id field, it appears to be firing when used, however the update to affiliate id is not happening.
Version info: 4.20.20.0 / 6.2.5
Debug shows this: Executing SQL Event
SQL Query: UPDATE dnn_users SET AffiliateId = 49 WHERE UserId = 1
Completion Event has this entry (LMS-ORGID is defaulted to 49 as a hidden field. This user's hidden field is correctly set to 49):
UPDATE dnn_users
SET AffiliateId = $(LMS-ORGID)
WHERE UserId = $(UserID)
What am I missing?
Thanks,
Matt