stmt:irows()

Execute a prepared statement using the currently assigned bind variables and return an iterator function. The column values will be returned as an integer indexed array.

db=sqlite.open('testdb')
stmt,err=db:prepare[[select x from foo where x between ? and ?]] stmt:bind(1,100)
for row in stmt:irows() do
sum=sum + row[1]
end