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

Moderator: ArturoRobles

#828381
Hi,
I'm not able to execute SQL Server stored procedures using the executequery. All queries work fine insert/update etc.
This is the code I use:
Code: Select all
$proc = @@PROCESS;
$result = executeQuery("SELECT DBS_UID FROM DB_SOURCE WHERE PRO_UID='$proc' " .
    "AND DBS_DATABASE_NAME='SHEET'");

if (!is_array($result) or count($result) == 0) 
    die("Error!");

$db = $result[1]['DBS_UID'];
executeQuery ("EXEC UPD_RDA '20200901164359363','123',''", $db);
Any idea how to solve?
Thanks in advance.
Attachments
Schermata del 2020-09-02 13-39-22.png
Schermata del 2020-09-02 13-39-22.png (72.38 KiB) Viewed 803 times

BPM programming permits organizations to advance t[…]

PROBLEM WITH DROPDOWN VALUE?..

Hello, I'm using a dropdown which load the info[…]

Convert PDF to base 64

Hi, anyone with a solution to this please?

Excellent read, Positive site, where did u come up[…]