TFS 1.1 Looping in a SQL table

[sircurse]

Hi folks,

I m trying to pass through a SQL table but I m getting the following error:

bad argument #1 to 'next' (table expected, got number)

I have the following script trying to do this looping:

local list = db.storeQuery("SELECT `id`, `owner` FROM `houses` WHERE `owner` != 0 ORDER BY `id` ASC;")

if list ~= -1 then
repeat

.... code .....

until not next(list)

The error shows on the line where I have the "until not next(list)" parameter.
For some reason it is not understand that my "list" are a table.

What am I doing wrong?

Curse.

 

[Ninja]

You forgot result. in front of next.

Change

until not next(list)

to

until not result.next(list)

 

[sircurse]

That is it, my bad... sorry! And thank you Ninja!