Here you go:

return $this->find (
    'list',
    array (
        'fields' => array ( 'Alert.message' ),
        'conditions' => array (
                'Alert.alert_subject_id' => strtoupper ( $subject ),
            'OR' => array(
                array(
                        'Alert.start_date'     => null,
                                'Alert.start_date <= ' => date ( 'Y-m-d H:i:s' )
                ),
                array (
                        'Alert.end_date'       => null,
                        'Alert.end_date >= '   => date ( 'Y-m-d H:i:s' )
                )
                        )
        )
    )
);
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to