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
-~----------~----~----~----~------~----~------~--~---
