#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
                 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 
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 
For more options, visit this group at 

  • [CakePHP : The Rapid Dev... CakePHP : The Rapid Development Framework for PHP

Reply via email to