Questions and discussion about using ProcessMaker 2: user interface, running cases and functionality

Moderators: ArturoRobles, ArturoRobles

Forum rules: Please search to see if a question has already been asked before posting. Please don't ask the same question in multiple forums.
#827566
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
#827640
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://www.youtube.com/channel/UCYiyz1y8Qf4EZjMXodwH1iw/videos
https://www.linkedin.com/in/pmlearning/
Thanks
CRUD and Process

Liliana i want to hear your answer if i say "[…]

Enabling SQL Server in Windows

I’m excited to uncover this page. I need to […]

Hi, Please use query like this: SELECT Forneced.[…]

Casos estão carregando em branco

Boa tarde! Prezados, estou com problemas em algun[…]