[nicolaj]

http://wiki.processmaker.com/index.php/ ... s#Examples

Example "Trigger 3" results in an error if syntax is:

@@Data = executeQuery('SELECT DESC, DESC2 FROM DESCRIPTION', 'DataSource1');
@@issueDesc1 = @@Data[1]['DESC'];
@@issueDesc2 = @@Data[1]['DESC2'];

Works:

$Data = executeQuery('SELECT DESC, DESC2 FROM DESCRIPTION', 'DataSource1');
@@issueDesc1 = $Data[1]['DESC'];
@@issueDesc2 = $Data[1]['DESC2'];

Best regards
Nicolaj

[nicolaj]

Correction:
My version doesn't work either (in a trigger). Just doesn't show any error

Could anybody confirm the example shows the following error?
syntax error, unexpected '[':

Regards
Nicolaj

[nicolaj]

Correct Syntax (for me):

@@Data = executeQuery('SELECT DESC, DESC2 FROM DESCRIPTION', 'DataSource1');
@@issueDesc1 = @=Data[1]['DESC'];
@@issueDesc2 = @=Data[1]['DESC2'];

regards
Nicolaj