[medoman]

Hey friends
sorry but i have a critical case here, i have the program manager dropdown list and the user can choose one value, then and at some times he can change this value if his manager request, and when the user change the program manager and press submit he got this error

Fatal error: Cannot use string offset as an array in C:\Bitnami\processmaker-3.0.1.8-0\apps\processmaker\htdocs\workflow\engine\classes\class.pmScript.php(246) : eval()'d code on line 1

- this is the trigger i run after the form to get the user id for the programme manager

@@programme_manager_id = executeQuery ("select USR_UID from users where USR_EMAIL = '". @@Programme."' ");
@@programme_manager_id = @@programme_manager_id[1][USR_UID];

[zainab]

In your trigger, you need to enclose the column USR_UID in single quotation marks when fetching the values, modify your trigger as:

Code: Select all

@@programme_manager_id = executeQuery("SELECT USR_UID from users where USR_EMAIL = '". @@Programme."'");
@@programme_manager_id = @@programme_manager_id[1]['USR_UID'];

What is stored in @@Programme? Is it a text field?

I think this might resolve the error.
Do let me know if this helps.

Best Regards,
Zainab

[medoman]

the @@manager holds the email address from the dropdown list, i run your trigger but it doesn't help... i think the problem is that the variable @@programme_manager_id is not empty. because when the user choose a program name for the first time the code is work and translate the email in @@programme variable to user id successfully , but when the user choose another program the fatal error appears.

[zainab]

This because you are using the same variable to store a string and an array. use two different variables.

Code: Select all

$res = executeQuery("SELECT USR_UID from USERS where USR_EMAIL = '". @@Programme."' ");
if(is_array($res))
{
@@programme_manager_id = $res[1]['USR_UID'];
}

This should work, if it doesn't could you please send your process so that I can take a better look at it and help you with a solution.

Best Regards,
Zainab

[medoman]

i think it is working... i will complete my test and tell you the final result..
thanks Zainab for your always support