|
Hi Mike Dado is just a library over LuaSQL. The select iteratorcreates a cursor (using LuaSQL's execute) and builds a function which calls its `fetch' method. Thus, it could let the cursor open.
However, for just 2 selects it should not be a problem don't you think? Can you send me a sample code? Regards, Tomás On Thu, 1 May 2008, Mike Schmitz wrote:
Tomas Guisasola Gorham wrote:Dado is a package that offers some facilities implemented over LuaSQL connection objects. Its main goals are: * better error messages, * iterators to access the result set and * more homogeneity in some commonly used database operations. Dado is free software and uses the same license as Lua 5.1. It can be downloaded from its LuaForge page: http://dado.luaforge.net/ Thanks, Tomás GuisasolaHandy tool. However, I am finding a small difficulty. I cannot run 2 select statements in a row, but every other works. I can run collectgarbage("collect") between them, and it works. I suspect it has to do with "cur" being still open. Is there a workaround, or am I just missing something fundamental?Mike