Sorry, I don't understand - the output you posted
Array
(
[0] => Array
(
[Transaction] => Array (...)
[Intermediator] => Array (...)
[Account] => Array (...)
[User] => Array (...)
)
[1] => Array ...
)
Has been modified from a normal mysql query result... in what way is
this a "flat" array?
What output are you trying to achieve?
On May 19, 11:39 am, David Christopher Zentgraf <[EMAIL PROTECTED]>
wrote:
> I see, thanks!
>
> I played around with finderQueries a bit more and got them to work to
> some extend, but not perfectly.
> Depending on which model I'm querying from, Cake throws away part of
> the results I'd like to keep, as it doesn't seem to think the result
> is related enough to the querying model.
>
> Is there a recommended/best way to implement custom queries?
> I'd hate to do it in the controller, so I was thinking about defining
> a bunch of custom Model functions and using raw SQL which I'll have to
> sort through. How does that work with table prefixes, for example?
> Will Cake still prefix my tables or how would I take care of that
> myself?
>
> Chrs,
> Dav
>
> On 19 May 2008, at 17:13, Filip Camerman wrote:
>
>
>
> > I don't think and wouldn't expect Cake to have any functionality to do
> > that; when you're rolling your own queries you've got to live with the
> > flat result. If you sort your query right (e.g. by user) then it
> > should be easy to rearrange the result in a hierarchical structure
> > though.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---