Lua getting varible from mysql

[resho]

Hello i got error.
My code is

function onThink(cid, interval, lastExecution)
local auction = db.query("SELECT `status` FROM `players` WHERE `name` = 'test';")
doBroadcastMessage("Example status is " .. auction .. " Bye")
end

Error Code
[Error - GlobalEvent Interface]
data/globalevents/scripts/eventcolor.lua:onThink
Description:
data/globalevents/scripts/eventcolor.lua:3: attempt to concatenate local 'auction' (a boolean value)
stack traceback:
data/globalevents/scripts/eventcolor.lua:3: in function <data/globalevents/scripts/eventcolor.lua:1>

What is wrong? Tfs 0.3.6pl1
Thanks you!

 

[Summ]

local auction = db.getResult("SELECT `status` FROM `players` WHERE `name` = 'test';")
local status = "Query result empty"
if auction:getID() ~= -1 then
    status = "Status: " .. auction:getDataInt("status")
    auction:free()
end

 

[resho]

Still bugged :< anyway thanks for fast reply.

[Error - GlobalEvent Interface]
data/globalevents/scripts/eventcolor.lua:onThink
Description:
data/globalevents/scripts/eventcolor.lua:4: attempt to index local 'auction' (a boolean value)
stack traceback:
        data/globalevents/scripts/eventcolor.lua:4: in function <data/globalevents/scripts/eventcolor.lua:1>

 

[Summ]

edited try again

 

[resho]

it works, but always auction is 0? (I was change variable in mysql database, I mean pool 'status' for example to 3)

pool status is type int