CakePHP list with SQL functions

Question

I would like generate list like day=>title:

$news = $this->News->find('list', array(
    'conditions' => array(
        'News.created LIKE' => '2008-09%'),
    'fields' => array(
        'DAY(News.created) AS day',
        'News.name'),
    'recursive' => -1));

...but doesn't work, why?

Function SUBSTR/SUBSTRING also...

When I use find with 'all' property, the function DAY works good!

What does "doesn't work" mean? What happens and what do you expect to happen? You have to be more specific, otherwise we won't be able to help you. — Felix Kling
– Felix Kling, Commented May 13, 2012 at 0:54
I know the question is already answered, but even "Generate incorrect list" is not really helpful. How should we know what "incorrect" is in this case? It is as useful as saying "does not work". You should provide an example of the list you get and the list you want. Keep that in mind for future questions. — Felix Kling
– Felix Kling, Commented May 13, 2012 at 18:11

bfavaretto · Accepted Answer · 2012-05-13 03:34:34Z

2

It won't work because DAY(News.created) is a computed value, but it will probably work if you make it a virtual field.

Note that when you use 'all', each row on the results array will have a [0][day] key for that value, instead of [News][day]. This means Cake won't recognize it as a field from model News, and that's why you can't use it with 'list'.

edited May 13, 2012 at 3:34

answered May 13, 2012 at 1:02

bfavaretto

72k18 gold badges118 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CakePHP list with SQL functions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related