[symfony-users] Re: Problem with Doctrine and Join/GroupBy query

2010-02-19 Thread Olivier
I've been tracking down this issue a little bit more within Doctrine code, especially within the hydrateResultSet function of the Doctrine_Hydrator_Graph object. There is a loop in this function, and I can see that it does fetch the two rows of data: rowData[v] = ([total]=100, [title] = 'prod_1')

[symfony-users] Re: Problem with Doctrine and Join/GroupBy query

2010-02-19 Thread Olivier
Another step on this issue... I've found a workaround: if I set the hydration mode to HYDRATE_NONE, I get the values as expected with several rows in the array. However, it's not so nice, since I have to do an array_combine to get the column names back in the array. If anyone would have a clue

[symfony-users] Re: Problem with Doctrine and Join/GroupBy query

2010-02-18 Thread Olivier
That could have been a reason. Unfortunately, I checked the data and they're all good. What I do not understand is that the query executed directly on mySQL show ywo records when I get only one via Doctrine... On Feb 18, 9:58 pm, Michał Piotrowski mkkp...@gmail.com wrote: Hi, 2010/2/18 Olivier