You may try to use 'SUBSTR(Post.description,0,50) as description' Enjoy, John
On Sep 21, 8:21 pm, "Dave Maharaj :: WidePixels.com" <[email protected]> wrote: > When doing a query how can i pull only a desired number of characters from a > field? > > I have: > > 'fields' =>array( > 'Post.title', > 'Post.created', > SUBSTR('description', 0, 50), > 'Post.id'), > > But this is wrong, > > Ideas? > > Dave --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
