如何在Doctrine 1.2中逐一获取结果？

Question

How can I make something similar to classic PHP PDO

while ($obj = $stmt->fetch()) {...}

in Doctrine 1.2.

I've tried

while ($obj = $query->fetchOne()) {...} 

but it returns always only the first object found.

Is there any way I could implement this behaviour?

Doesn't really matter my query. It's a plain simple one (note that I am in the *Table class of the model)

$query = $this->createQuery('a');

Answer 1

Have you tried:

while ($obj = $query->execute()) {...}

And if you want to fetch an array instead of objects:

while ($obj = $query->execute(array(), Doctrine_Core::HYDRATE_ARRAY)) {...}