Re: SQL expressions in paginate or find

2008-09-26 Thread phpcurious

I don't know what exactly you want to achieve , but it is best that
you read over the manuals on
how to make paginations work.

http://book.cakephp.org/view/164/Pagination


On Sep 27, 2:04 am, "Eric C. Weaver" <[EMAIL PROTECTED]> wrote:
> In one model's (controller's) index action, I'd like to fetch an
> additional column to tell whether the timestamp field is recent.
> What I'd like to be able to do (and tried unsuccessfully) would be
> something like
>
> $this->paginate['fields'] = array('Model.*', "(ts > current_timestamp
> - interval '4 hours')");
>
> Any clues how to do this?
>
> Thanks...
--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---



SQL expressions in paginate or find

2008-09-26 Thread Eric C. Weaver

In one model's (controller's) index action, I'd like to fetch an
additional column to tell whether the timestamp field is recent.
What I'd like to be able to do (and tried unsuccessfully) would be
something like

$this->paginate['fields'] = array('Model.*', "(ts > current_timestamp
- interval '4 hours')");

Any clues how to do this?

Thanks...

--~--~-~--~~~---~--~~
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 [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---