Hi,

Is it possible to do a fetchAll with a specified classname as resultobject?

For a single row, I can do this:
[PHP]$users = new Users();
$select = $users -> select();
$select -> from("users", Array('userId', 'username', 'fullname', 'email', 'lastlogin', 'isadmin'));
$stmt = $this -> db -> query($select);
$user = $stmt -> fetchObject("User");
return $user;[/PHP]

But I want to have a list of users, not a single user.
So something like this:
[PHP]
$stmt = $this -> db -> query($select);
$user = $stmt -> fetchAll("User");[/PHP]

The reason I want to have this is because I want (need) classmapping between my Flex application and PHP.
Please help!

RTFM
Zend Framework: Documentation

I allready have the set the setFetchMode to Zend_Db::FETCH_OBJ. Which indeeds makes the result set an array of objects. But I can't specify what kind of object to use.

? what do you mean by what kind of object?

If want to specify a class as objecttype, instead of php's standard StdClass.

my class looks something like this:
[PHP]
class User {
var $_explicitType = "User";

public $userId = 0;
public $username = "";
public $password = "";
public $fullname = "";
public $email = "";
public $lastlogin = "";
public $isadmin = false;

}[/PHP]

So when I do a fetchAll, I want an array of User classes.

i think you can't specify it, but take a look at fetchAll method.. you can always extend it so it will except class name...

I use a fetchResults method in my models that replaces $db->fetchAll (calls it internally), for adding in things like pagination handling, converting to objects, etc.

AFAIK there's no way to do it automatically.

FetchAll should work as PDO:

PHP Tutorials Examples Introduction to PHP PDO

Or if your using a Zend_Db_Table_Abstract object to do the query you can set the protected propert "$_rowClass" and "$_rowsetClass" which will mean object(s) of that type are returned assuming they extend the Zend_Db_row_Abstract (i think) class.

finally I had to use the "Value Object" approach as noticed here:

Utilizing the Zend AMF Server Inside a Zend Controller | blog.log2e.com