Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

[SOLVED] What is the correct trigger?

  • Roland
  • Roland
  • OFFLINE
  • Posts: 161
  • Thanks: 16
  • Karma: 11
11 years 8 months ago - 11 years 8 months ago #221112 by Roland
Replied by Roland on topic Re: 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

www.simple-quality.de - The Quality-Web-Portal
Attachments:
Last edit: 11 years 8 months ago by Roland.

Please Log in or Create an account to join the conversation.

  • Roland
  • Roland
  • OFFLINE
  • Posts: 161
  • Thanks: 16
  • Karma: 11
11 years 8 months ago #221146 by Roland
Replied by Roland on topic Re: What is the correct trigger?
Hello,

this is solved now...

I used the wrong and less ''...

Thanks

Greetings, Roland

www.simple-quality.de - The Quality-Web-Portal
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum