#6284: Aliasing a resultset using model::query() with PostgreSQL does not exhbit doc behavior. --------------------------+------------------------------------------------- Reporter: eberon | Type: Bug Status: new | Priority: Medium Milestone: 1.2.x.x | Component: PostgreSQL Version: 1.2 Final | Severity: Normal Keywords: | Php_version: PHP 5 Cake_version: | --------------------------+------------------------------------------------- == Introduction ==
The second example in model::query at http://book.cakephp.org/view/456/query states that using an alias in a SELECT query should return an alias-indexed result set array instead of a numerically indexed array. == Code == Even using a query as simple as the sample one fails: {{{ function getObjectsinBounds($bounds) { $results = $this->query("SELECT * FROM facilities AS Facility"); return $results; } }}} The resultset is numerically indexed. Using find() on the other hand, works fine, because this behavior is automatic for those methods. == Expected Behavior == Result arrays should be indexed numerically, then by specified alias name. == Effects == This particularly affects my ability to use Javascript::Object to convert resultsets into usable and addressable JSON - Object() creates two nested anonymous objects with the resultant array. -- Ticket URL: <https://trac.cakephp.org/ticket/6284> CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/> Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "tickets cakephp" group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to tickets-cakephp+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~----------~----~----~----~------~----~------~--~---