db:first_irow(sql)

Execute a SQL statement and return the first row of data.

Example

db=sqlite.open('testdb')
row=db:first_irow[[select max(x) from foo]]

max_x = row[1]