03.12.2021, 08:01
Hello. Please tell me. How can I get the result of a query as a chill, so that a condition can be made to check the result. The query displays the result in tabular form
Query Result
Code:
count = dbcon:execute('SELECT COUNT(period) FROM total_energy WHERE period = "day"')
row = count:fetch({}, 'a')
log(row)
Code:
* table:
["COUNT(period)"]
* string: 9