[Kamil123]

Hello Everyone,
I have a problem in fetching the data from MS SQL Server,
I'm writing a very simple query to fetch the Customer's Id and Name in the Dropdown List, but I getting the below error

Notice: Array to string conversion in C:\opt\processmaker\gulliver\thirdparty\creole\SQLException.php on line 63

The SQL query as below, it`s working fine in SQL studio Management:

Code: Select all

select distinct iRepresentanteAtual, NomeGrupoRep FROM qryMapaClientes order by NomeGrupoRep

I'm using a PM 2.8 on Windows 10 and using Xampp V3.2.2 ( Apache/2.4.29 (Win32) OpenSSL/1.0.2n PHP/5.6.33 Apache 2.4 )

Any suggestions, please

[programerboy]

Hi,
Please disable notice error in your server config.

https://pmlearning.info
Thanks

[Kamil123]

Thank you for your replay,
I did that without sucsess, I`m still have the below error!

Notice: Array to string conversion in C:\opt\processmaker\gulliver\thirdparty\creole\SQLException.php on line 66

[programerboy]

Hi,
Please write your query in a trigger before your dynaform like this:

Code: Select all

$db = 'Your connection uid';
$query = 'Your query';
$result = executeQuery($query, $db);
print_r($result);
die();

Then check your result is true or not. You can fill your dropdown with trigger before your form.

https://pmlearning.info
Thanks