06.09.2019, 08:29
Hi
I am having some trouble getting a number from the SQL COUNT.
I am using this conde:
The result I get from this in the log is then;
* table:
[COUNT()]
* number: 569
What I need is to just get the number stored in the variable, not the entire table. Any good tips for me?
I am having some trouble getting a number from the SQL COUNT.
I am using this conde:
Code:
ant = db:getrow('SELECT COUNT() FROM objects WHERE name LIKE "%status%"')
log(ant)The result I get from this in the log is then;
* table:
[COUNT()]
* number: 569
What I need is to just get the number stored in the variable, not the entire table. Any good tips for me?
There are 10 kinds of people in the world; those who can read binary and those who don't 