Nope, won't work. I've tried 'FOO() AS Table.field', 'FOO() AS
`Table`.`field`' and 'FOO() AS `Table.field`'. The first 2 are invalid
SQL, the last one isn't parsed by cake properly. afterFind() is the
only way I've found to do this.
On Oct 23, 3:43 am, dardosordi <[EMAIL PROTECTED]> wrote:
> You can try putting 'SUBSTRING_INDEX("content", " ", 20) AS
> Announcement.teaser'
>
> On Oct 22, 6:06 am, grigri <[EMAIL PROTECTED]> wrote:
>
> > Model::findAll() only indexes fields that are present in the database;
> > anything else is returned as you see (numeric index).
>
> > You can write an afterFind() callback in your model to insert the
> > fields into the correct positions.
>
> > On Oct 19, 11:15 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> > wrote:
>
> > > Hey,
>
> > > I am trying to do this:
> > > $this->set('announcements', $this->Announcement->findAll(null,
> > > array('id', 'name','SUBSTRING_INDEX("content", " ", 20) AS teaser',
> > > 'pic_filename'), 'add_date DESC'));
>
> > > and it doesn't work properly ..
>
> > > here is part of the dump of the resulting object:
> > > array(2) {
> > > ["Announcement"]=>
> > > array(3) {
> > > ["id"]=>
> > > string(1) "2"
> > > ["name"]=>
> > > string(18) "Stire senzationala"
> > > ["pic_filename"]=>
> > > string(8) "nicu.jpg"
> > > }
> > > [0]=>
> > > array(1) {
> > > ["teaser"]=>
> > > string(7) "content"
> > > }
> > > }
>
> > > Any help would be apreciated!
>
> > > Thx
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
