Re: Performing a Query using a curdate as condition, help asap?

2009-01-26 Thread RichardAtHome 

$this->Event->find('all',array(
'conditions' =>array(
'event_category_id'=>$catId,
'DATE(Event.event_date) > getdate()'
),
'order'=>array('Event.event_date ASC',
'Event.event_time ASC'
)
) ) ;

On Jan 26, 9:38 am, Martin Westin  wrote:
> There are lots of goodies you can use (for MySQL at least).
>
> Datediff is my preferred comparison since it does not fail on leap-
> years and things like that.
> DATEDIFF(date1,date2) > 0
> -> true or false
>
> To construct modified versions of today I sometimes use Addate adn
> Subdate
> ADDDATE(CURDATE(), INTERVAL 4 HOUR)
> -> 2009-01-26 04:00:00
>
> /Martin
>
> On Jan 26, 12:53 am, Parris  wrote:
>
> > Hi Everyone,
> > I am just trying to perform a simple query using cakephp. In the
> > conditions array I am trying to filter by dates. The results should be
> > all 'events' that will be today or greater (in other words, any date
> > in the future).
>
> > $this->Event->find('all',array( 'conditions' =>array
> > ('event_category_id'=>$catId,'DATE(Event.event_date)'=>'getdate
> > ()'),'order'=>array('Event.event_date ASC','Event.event_time
> > ASC') ) ) ;
>
> > That is what i have so far. The first condition is just to filter by
> > category. The part I need help with is 'DATE
> > (Event.event_date)'=>'getdate()'). There are no errors. So i guess its
> > kind of working. Also how can i adjust 'today' by 4 hours ?
>
> > 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 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Re: Performing a Query using a curdate as condition, help asap?

2009-01-26 Thread RoVo 

Hi Parris,

> The results should be all 'events' that will be
> today or greater (in other words, any date
> in the future).
Try it like this:

'conditions'=>array(
'Event.event_date >= ' => date('Y-m-d')
)


Hope that helps
RoVo


--~--~-~--~~~---~--~~
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 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Re: Performing a Query using a curdate as condition, help asap?

2009-01-26 Thread Martin Westin 

There are lots of goodies you can use (for MySQL at least).

Datediff is my preferred comparison since it does not fail on leap-
years and things like that.
DATEDIFF(date1,date2) > 0
-> true or false

To construct modified versions of today I sometimes use Addate adn
Subdate
ADDDATE(CURDATE(), INTERVAL 4 HOUR)
-> 2009-01-26 04:00:00


/Martin



On Jan 26, 12:53 am, Parris  wrote:
> Hi Everyone,
> I am just trying to perform a simple query using cakephp. In the
> conditions array I am trying to filter by dates. The results should be
> all 'events' that will be today or greater (in other words, any date
> in the future).
>
> $this->Event->find('all',array( 'conditions' =>array
> ('event_category_id'=>$catId,'DATE(Event.event_date)'=>'getdate
> ()'),'order'=>array('Event.event_date ASC','Event.event_time
> ASC') ) ) ;
>
> That is what i have so far. The first condition is just to filter by
> category. The part I need help with is 'DATE
> (Event.event_date)'=>'getdate()'). There are no errors. So i guess its
> kind of working. Also how can i adjust 'today' by 4 hours ?
>
> 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 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Performing a Query using a curdate as condition, help asap?

2009-01-25 Thread Parris 

Hi Everyone,
I am just trying to perform a simple query using cakephp. In the
conditions array I am trying to filter by dates. The results should be
all 'events' that will be today or greater (in other words, any date
in the future).

$this->Event->find('all',array( 'conditions' =>array
('event_category_id'=>$catId,'DATE(Event.event_date)'=>'getdate
()'),'order'=>array('Event.event_date ASC','Event.event_time
ASC') ) ) ;

That is what i have so far. The first condition is just to filter by
category. The part I need help with is 'DATE
(Event.event_date)'=>'getdate()'). There are no errors. So i guess its
kind of working. Also how can i adjust 'today' by 4 hours ?

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 
cake-php+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---