lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]


Has anyone had luck with PRAGMAs using a recent sqlite and LuaSQL version? Retrieving results seems to be broken:

Lua 5.1.4 Copyright (C) 1994-2008 Lua.org, PUC-Rio
> require"luasql.sqlite3"
> env = luasql.sqlite3()
> env:connect("/home/vadi/Desktop/test")
> conn = env:connect("/home/vadi/Desktop/test")
> =type(conn)
userdata
> =conn
SQLite3 connection (0xc0bc58)
> cur = conn:execute("PRAGMA table_info('people')")
> =cur
SQLite3 cursor (0xc10218)
> row = cur:fetch({}, "a")
> =row
nil


There's been a similar post on Kepler (http://lists.luaforge.net/pipermail/kepler-project/2010-September/004338.html), not much of a conclusion out of that except that LuaSQL is starting to become outdated...