I need to add the current date to a custom user field at the time a subscription is made. I don't see a way to do that in the sub Integration tabs... so I thought maybe I could add it using a SQL query. Here's way I can so far. It doesn't see to have an effect.

UPDATE '#_comprofiler' SET 'cb_customfield' = CONVERT (date, GETDATE()) WHERE `user_id` = [user_id]

Thoughts?

Todd

The fields doesn't change when I add the subscriptions to a user. It remains blank.

I added a custom field called cb_workshop001. It is a date type. The field-specific parameters are default. I haven't touched the CBSubs Fields Tab Protect... area.

The SQL string is copied and pasted in to the SQL Action 1 on ACTIVATION area.

Yet when I add the subscription to the a user, the cb_workshop001 field remains empty.

Help.

Thanks.
Todd

Thanks for the reply. I still don't have the custom field updated.

The difficult thing is that there is not error message or log to see it the SQL is invalid and why. Do you know of a way to test it? Maybe using phpMyAdmin?

thanks
Todd

I just tried phpMyAdmin and the following worked:

UPDATE `jos_comprofiler` SET `cb_workshop001` = DATE_FORMAT( CURDATE(), '%Y-%m-%d' ) WHERE `user_id` = 66

But then I put the following in cbSubs... and the field is still blank:

UPDATE `jos_comprofiler` SET `cb_workshop001` = DATE_FORMAT( CURDATE(), '%Y-%m-%d' ) WHERE `user_id` = [user_id]

Thoughts?

Todd