Anonymous

-- Below example fails when postgres returns more than 1 row with lua Dbh
-- Latest checkout from repository: Sat Mar 10 22:56:29 2012 -0500 (commit 5e4a514531de2a1d8040c3d306a9e8de426de566)

db = freeswitch.Dbh("dsn");

assert(db:connected());

local query = "SELECT field1, field2 FROM table";     -- returns multiple rows
local results = {};

db:query(
  query,
  function(row)
    table.insert(results, row);
  end
);

-- The above fails in callback function as far as I can tell with following lua error

2012-03-16 02:28:05.571762 [ERR] mod_lua.cpp:102 attempt to call a nil value
stack traceback:
        [C]: in function 'query'
        database.lua:28: in function 'dbGetAll'
        [C]: in function 'require'
        ?: in main chunk
2012-03-16 02:28:05.571762 [ERR] mod_lua.cpp:198 attempt to call a nil value
stack traceback:
        [C]: in function 'query'
        database.lua:28: in function 'dbGetAll'
        [C]: in function 'require'
        ?: in main chunk
stack traceback:
        [C]: in function 'query'
        database.lua:28: in function 'dbGetAll'
        [C]: in function 'require'
        ?: in main chunk