Re: Undefined Index error when using COUNT() AS

Did you debug($post)? Cake put the test value under a different array
because you used a function. See this for a neat workaround:

http://teknoid.wordpress.com/2008/09/29/dealing-with-calculated-fields-in-cakephps-find/

On Wed, Apr 29, 2009 at 6:51 AM, Danno <daniel.korel@gmail.com> wrote:
>
> Can't figure out why i get the undefined index error, when using
> "COUNT() AS test" in my query...
>
> I've tried a whole range of different ways of writing the SQL (cake
> format and just straight SQL)
>
> Seems that the view just doesn't pick up the name given after AS as a
> valid field... all other fields that actually occur in the table get
> recognised...
>
> --Controller
>        $conditions = array('fields' => array('*','COUNT(id) as
> test'), 'group' => 'id');
>        $posts = ClassRegistry::init('Calendar')->find('all',
> $conditions);
>        $this->set( 'posts', $posts);
>
> --View
> <?php foreach ($posts as $post): ?>
> <tr>
> <td><?php echo $post['Calendar']['date']; ?></td>
> <td><?php echo $post['Calendar']['test']; ?></td>
> </tr>
> <?php endforeach; ?>
>
> Hope someone can help...
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---