Welcome Guest, Not a member yet? Register   Sign In
Doctrine 1.2.2 Usage Problem
#1

[eluser]djmccormick[/eluser]
Hello Everyone,

I have a question about Doctrine (I'm using 1.2.2 and integrated using this guide) 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:
Code:
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:
Code:
Array
(
    [0] => Array
        (
            [id] => 1
            [username] => bbarker
            [password] => $1$LF7Rkevp$mROyY2ijf6g94R1VyuL0Q0
            [first_name] => Bob
            [last_name] => Barker
            [email_address] => [email protected]
            [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


Messages In This Thread
Doctrine 1.2.2 Usage Problem - by El Forum - 05-01-2010, 02:13 AM
Doctrine 1.2.2 Usage Problem - by El Forum - 05-01-2010, 05:46 AM
Doctrine 1.2.2 Usage Problem - by El Forum - 05-01-2010, 06:00 AM
Doctrine 1.2.2 Usage Problem - by El Forum - 05-01-2010, 07:49 AM



Theme © iAndrew 2016 - Forum software by © MyBB