That does look nice. While I was trying to avoid looping over the resultset, this little nugget might be very handy in AppModel, as you suggest. Thanks!
On Thu, Jan 29, 2009 at 2:03 AM, teknoid <[email protected]> wrote: > > Not a one-liner, but perhaps it'll be helpful... > > http://teknoid.wordpress.com/2008/09/29/dealing-with-calculated-fields-in-cakephps-find/ > > On Jan 29, 1:50 am, brian <[email protected]> wrote: >> Paging grigri ... ;-) >> >> I have some data that is the result of a stored procedure call that >> I'm struggling to re-shape into a more desirable array. One of the >> selected columns is the result of a CASE block which checks values >> from a couple of tables, returning the appropriate field. As such, >> Cake can't give me a model key and puts it under "0" (zero). I'd like >> to move the value under that to inside the other array. >> >> This appears so simple, yet I've tried--and failed--with all sorts of >> Set::extract/merge/combine ... er, combinations. I know I can use >> map() but creating a callback seems like overkill for something that >> will *never* be used anywhere else in the app. I could do it in a >> foreach loop with a tmp array but, well, what's the point of that? >> >> Let's have a look: >> >> Array >> ( >> [0] => Array >> ( >> [Model] => Array >> ( >> [id] => 227 >> ) >> >> [0] => Array >> ( >> [foo] => some string // <- my CASE block field >> ) >> >> ) >> >> [1] => Array >> ( >> [Model] => Array >> ( >> [id] => 228 >> ) >> >> [0] => Array >> ( >> [foo] => some other string >> ) >> >> ) >> // etc ... >> >> I'd like it to be in this form: >> >> Array >> ( >> [0] => Array >> ( >> [Model] => Array >> ( >> [id] => 227 >> [foo] => some string >> ) >> >> ) >> >> [1] => Array >> ( >> [Model] => Array >> ( >> [id] => 228 >> [foo] => some other string >> ) >> >> Can anyone point me in the right direction? I'm sure this is a Set >> class one-liner. >> >> btw, I've grown to love the Set class but have yet to see a clear >> explanation of the params that Set::combine takes. I've seen examples >> here on the list but have never been able to figure out what makes >> them work. I'd really appreciate a clue on that. > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
