I try to populate a text field (@@EMAIL_DA1) with an email address for a database using executeQuery in a trigger.
Here is the code I try to execute in a trigger:
$DB = '3180815915aaa5b6b2f1962098817046';
$CODEUO = @@LD_UO; // LD_UO is a Dynaform variable containing a unique key
$query1 = "select distinct UtilisateurTitulaire_Email from V_REF_ELEMENTORGANISATION where ElementOrganisation_CodeElementOrganisation = '$CODEUO'";
$result1 = executeQuery($query1, $DB);
@@EMAIL_DA1 = $result1;
Unfortunately, I obtain [object Object] result instead of an unique email address.
Could you help me to obtain the correct result ?
Thank you for advance !