I can't help you with mssql or aliases, but I might be able to help with the json stuff. If I understand you correctly, you are wanting to get your data into a good json format (ie - not have the data nested in so many arrays). You might Set::extract(). You can find a short tutorial here: http://www.thinkingphp.org/2007/02/24/cake-12s-set-class-eats-arrays-for-breakfast/
I have an example that uses this to create a json string here: http://www.ntatd.org/mark/?p=29. I hope that helps some. I know it's not what you actually asked for, but maybe it will help in the mean time. hydra12 On Jan 16, 7:14 am, Fraed <[EMAIL PROTECTED]> wrote: > Hi, > > i am using Cakephp 1.2.0.6311 beta with mssql. > > Im trying to use Alias-Names in the findAll()-Method. (eg in SQL: > SELECT name AS text from table). Everytime setting up the field > parameter like array('name AS text') the returned Array-Structure is > unusable. A value would be accessable as: > > $data[0][Model][0][Model][0]['text'] instead of $data[0][Model][text] > > Fields without an Alias have their right place. > > Is there any way to work with aliases and set up the Array structure > correctly? This would be very helpful to encode some json_data and > maybe also for other things. Maybe the defnition in the field array is > wrong. But theres no hint where aliases can be defined on other > points. Is it working with mysql? Cant test it here in Company. > > Thanks for your help > > Fraed --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
