It is already reported. Have a look at
https://trac.cakephp.org/ticket/6135 I consider this one being a serious bug and a blocker. Hopefully it gets fixed soon, I already check the dev version in Subversion but nobody took up on this one. I would be glad for a workaround. On 12 Mrz., 17:56, Miguel XT <migu...@gmail.com> wrote: > I have this exact problem. This seems to be bug with 1.2 and > dbo_mssql. > > On Mar 2, 1:46 pm, Alexey <grunic...@gmail.com> wrote: > > > I need to have application that can work in either MySQL or MSSQL > > environment. > > Due to db-abstractions all work fine if I'm using find() and other > > methods. > > But sometimes I need to use query() function for big and hard queries. > > Here I have one issue. > > I'm going to use simple examples, of course real queries are > > different. > > var_dump($this->MyModel->query("SELECT * FROM users as u, > > user_sessions as us")); > > > Mysql returns: > > array > > 0 => > > array > > 'u' => > > array > > 'id' => string '1' (length=1) > > 'username' => string 'test' (length=4) > > 'password' => string 'password' (length=40) > > 'us' => > > array > > 'id' => string '1' (length=1) > > 'user_id' => string '1' (length=1) > > 'created' => string '2009-03-02 15:20:28' (length=19) > > 'closed' => null > > 'last_update' => null > > 'last_save' => null > > > MSSQL returns: > > array > > 0 => > > array > > 0 => > > array > > 'id' => string '1' (length=1) > > 'username' => string 'test' (length=4) > > 'password' => string 'password' (length=40) > > 'user_id' => string '1' (length=1) > > 'created' => string 'Dec 29 2008 5:08PM' (length=19) > > 'closed' => null > > 'last_update' => null > > 'last_save' => null > > > So, first thing - we don't have aliases, second thing - mssql merged > > both tables output in one array. > > > If I use find() alises work fine in MSSQL (as well as in MySQL), how > > can this problem be solved for query() function? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---