djmccormick

Hello Everyone, I have a question about Doctrine (I'm using 1.2.2) and the way to query for data. Here is my code: Bootstrap: http://pastie.org/941280 Model: http://pastie.org/941275 Controller: http://pastie.org/941278 Controller debugging output: http://pastie.org/941290 Notice the controller and controller debugging output. I'm selecting only the username in the controller. The query it is generating according to echo $query->getSqlQuery() looks like this: SELECT u.id AS u__id, u.username AS u__username FROM user u Yet the array returned by $users->toArray() has every field populated: Array ( [0] => Array ( [id] => 1 [username] => bbarker [password] => $1$LF7Rkevp$mROyY2ijf6g94R1VyuL0Q0 [first_name] => Bob [last_name] => Barker [email_address] => foo@bar.com [created_at] => [updated_at] => ) ) I don't understand why it is returning all data and not simply the field I requested. In the Doctrine 1.2 documentation they show a similar example (it's the first example under this heading) and it's not getting every field. There is a slot for every field but those that weren't requested are blank. Thank you in advance for any advice and tips from everyone. Regards, Dustin