Funny, I just did something similar to this yesterday :)
// used because i had multiple conditions.
$conditions = array();
// if you're using DATETIME like the created and updated fields do,
you
// should even be able to leave off the H:m:s if time is irrelevant
$conditions[] = "`Course`.`date` > " . "'" . date( 'Y-m-d H:m:s' ) .
"'";
$this->set('courses', $this->Course->findAll($conditions));
And if you want, say, the last 7 days, you can use strtotime() to
provide different date ranges. I make no claims as to speed, but it
"works for me".
There is more information in the manual under "Complex Find
Conditions" here: http://manual.cakephp.org/chapter/models
Best of luck,
Ralph
On Feb 6, 4:10 pm, "jeroen" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm pretty new to cakephp, so the answer is probably pretty obvious,
> but I'm struggling on this for too long now...
>
> One of my models (say 'Course') has a date field, and in the index()
> method where I would like to pass only those records which have a date
>
> > 'now'.
>
> However I have no idea how to define such a constraint. From what I
> found by googling around, I assembled the following, but it does not
> work (no records selected):
>
> function index() {
> $constraint['Course.date'] = ' > '. date('Y-m-d H:i') ';
> $this->set('courses', $this->Course->findAll($constraint));
> }
>
> I'm using 1.1.13.4450
>
> Any hints are appreciated,
> jeroen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
