stmt:cols()

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

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

end