Lua Return number of rows from select in lua

Sacarus · Oct 7, 2017

Hi, sorry for the dumb question, but I just cant get the number of rows returned by a select. I tried using while result.next(data) and it loops just two times, executing the same code in sql returns 4 rows.
The following code prints "false". Does anyone know how to get that COUNT(*) ?? Any other way to get the total of rows returned gonna work, just tell me if you know some.

Lua:

local data= db.query("SELECT COUNT(*) FROM(SELECT * FROM `player_coins` WHERE `player_id` = 1) x")
  if data~= false then
    local lines= result.getDataInt(data, "COUNT(*)")
    print(lines)
  end

Thank you!

pasiak12 · Oct 7, 2017

try

Lua:

local data= db.query("SELECT count(*) FROM `player_coins` WHERE `player_id` = 1")
  if data then
    print(data)
  end

Sacarus · Oct 7, 2017

The select works, but it 's printing "false" using
local lines= result.getDataInt(data, "COUNT(*)")

pasiak12 · Oct 7, 2017

Doesn't data already contain the 4 number? Try to print data.

Sacarus · Oct 7, 2017

It returns "true"

ond · Oct 7, 2017

Lua:

    local data = db.query("SELECT COUNT(*) FROM `player_coins` WHERE `player_id` = 1;")
    if data then
        print(data:getDataInt('data'))
    end

Infernum · Oct 7, 2017

Lua:

local res = db.storeQuery("SELECT COUNT(*) FROM `player_coins` WHERE `player_id` = 1")
print(result.getNumber(res, "COUNT(*)"))

use db.storeQuery when you want to get values from the result, db.query just returns true/false based on success of execution

River KA · Oct 7, 2017

TFS 1.x

Lua:

    local count = 0
    local resultId = db.storeQuery("SELECT COUNT(*) AS `count` FROM `player_coins` WHERE `player_id` = 1;")
    if resultId ~= false then
        count = data:getDataInt('count')
        result.free(resultId)
    end
    print(count)

Sacarus · Oct 10, 2017

Sorry for the delay. I tried all your suggestions and always was printing "false", like there was not an int value to get from 'count', even with storeQuery.
But, I found some example in playerdeath that worked:

Lua:

  local resultId = db.storeQuery("SELECT `player_id` FROM `player_coins` WHERE `player_id` = 1")

  local rows = 0
  local tmpResultId = resultId
  while tmpResultId ~= false do
    tmpResultId = result.next(resultId)
    rows = rows + 1
    print(rows)
  end

Thank you all, guys

pasiak12 · Oct 10, 2017

User Static_ told you the solution with storeQuery function. Your new script is using the same. His post should be marked as answer.

Sacarus · Oct 10, 2017

No problem, I changed. Anyway, even with storeQuery, it was printing "false", I tried all the codes people gave me here, using storeQuery instead of query, I only got "false" like there was not Int value in result. It just worked using storeQuery in a "while" with result.next(query). I dont know why, but, didn't work trying to get the select's value (count). I needed to count the rows in lua script, not in sql. Thank you static_told.

Lua Return number of rows from select in lua

Sacarus

Member

Infernum

pasiak12

Well-Known Member

Sacarus

Member

pasiak12

Well-Known Member

Sacarus

Member

ond

Veteran OT User

Infernum

︈

River KA

Veteran OT User

Sacarus

Member

pasiak12

Well-Known Member

Sacarus

Member

Similar threads