Lua SQL: peeking at cursors

Question

I am using LuaSQL, and query for a result set using con:execute(sql_stmt), which returns a cursor.

How do I see if there is at least one row in that resultset, without doing a cursor:fetch to pop that first row?

Answer 1

From the doc it appears you can use cur:numrows() if you are using MySQL, PostgreSQL, or Oracle:

cur:numrows() See also: cursor objects Returns: the number of rows in the query result.