get a integer value from a tigger

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.

3 posts
First unread post

3 posts

get a integer value from a tigger#829888

By H3Dott - Mon Apr 25, 2022 8:58 am

- Mon Apr 25, 2022 8:58 am #829888

I want to get the last row of a pmt table before dynaform with these codes:

Code: Select all

$all = executeQuery("SELECT COUNT(GOOD_CODE) FROM PMT_STOCK"); 
$code = $all + 1;

But result of $code is 1 because value of $all is [object Object].
what should I do?
------------------------------------------------------------
Also, I try these codes:

Code: Select all

$code = $all[1][COUNT(GOOD_CODE)] + 1

But did not get a result.

Last edited by H3Dott on Mon Apr 25, 2022 9:10 am, edited 1 time in total.

Re: get a integer value from a tigger#829895

By ronrich - Wed Apr 27, 2022 9:58 am

- Wed Apr 27, 2022 9:58 am #829895

Hello H3Dott,

The execute query will return an array object, therefore you'll get the [object object] result.

Try this:

Code: Select all

$all = executeQuery("SELECT COUNT(GOOD_CODE) AS LAST_RECORD FROM PMT_STOCK"); 
$code = $all[1]['LAST_RECORD'] + 1;

find more information about the executeQuery function here: https://wiki.processmaker.com/3.2/ProcessMaker_Functions/Database_Functions#executeQuery.28.29

I hope this helps.

Re: get a integer value from a tigger#830162

By H3Dott - Mon Aug 29, 2022 2:27 pm

- Mon Aug 29, 2022 2:27 pm #830162

ronrich wrote: ↑Wed Apr 27, 2022 9:58 am Hello H3Dott,

The execute query will return an array object, therefore you'll get the [object object] result.

Try this:
Code: Select all
$all = executeQuery("SELECT COUNT(GOOD_CODE) AS LAST_RECORD FROM PMT_STOCK"); 
$code = $all[1]['LAST_RECORD'] + 1;
find more information about the executeQuery function here: https://wiki.processmaker.com/3.2/ProcessMaker_Functions/Database_Functions#executeQuery.28.29

I hope this helps.