Post to CB field from RSForm Pro

I'd like insert a value from a basic RSForm in to a CB field. It looks like this should work but it doesn't and RSForm themselves are also not sure. A search of the CB forum reveals nothing of use.

UPDATE `xxx_comprofiler` SET `user_id`='{global:userid}' WHERE `cb_upgradeinformation` = '{Upgrade_information:value}'

Any suggestions from anyone who has succeeded?

Thanks

Your query is reversed. Your SET should be for your field and your WHERE should be for your user id. As is you may have incorrectly broke user records doing that. Run the below to fix your records (note this only needs to be ran once.. generally just run it in phpmyadmin).



Next adjust your query to the below.