[ludovicsantaroni]

Hello,

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 !

[programerboy]

Hi,
Please change your code like this:

Code: Select all

$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[1]['UtilisateurTitulaire_Email'];

https://pmlearning.info
Thanks

[ludovicsantaroni]

It works correctly like this, thank you very much !