Using assertexec from Dado and ODBC driver (ms-sql server), I could iterate
this way:
local cur = db:assertexec("exec your_stored_procedure_name")
local row = cur:fetch ({}, "a")
while row do
-- do something
row = cur:fetch ({}, "a")
end
cur:close()
Regards,
Vagner
2010/10/20 Dewey Gaedcke <de...@minggl.com>
> Is anyone aware of any documentation or examples showing how to iterate
> over the results (cursor) returned from a stored procedure call (using
> either exec or assertexec from Dado or any other Luasql method) ?
>
> And thanks in advance for any references you can provide.
>
> Regards,
> Dewey
> _______________________________________________
> Kepler-Project mailing list
> Kepler-Project@lists.luaforge.net
> http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project
> http://www.keplerproject.org/
>
_______________________________________________
Kepler-Project mailing list
Kepler-Project@lists.luaforge.net
http://lists.luaforge.net/cgi-bin/mailman/listinfo/kepler-project
http://www.keplerproject.org/
