[SOLVED] What is the correct trigger?

Hello,

Ok - I tested the trigger and it works correctly. For testing i used as typ "Field" and let a testfield changing.

Now I want, that every time the field [cb_bannerlink] is updated the value also saved in the link-field of the Joomla-Core-Banner-Component field (jos_banners => clickurl):



I used as query-code:
UPDATE `jos_banners` SET `clickurl` = [cb_bannerlink] WHERE `id` = [cb_bannerid]



The field cb_bannerid is also in the profile and equal to the number in jos_banners:





I think my failure is in the query... Or is it possible at all that the query change a database field from a other component?

Greetings, Roland

Hello,

this is solved now...

I used the wrong and less ''...

Thanks

Greetings, Roland