Make sure debug is on and check the Query that is being written.
I, personally, have never used the "BETWEEN" for MySQL. I usually have
something like:
$from = ....
$to = ....
$condition = array('date' => "date > $from and date < $to");
But that's just me.
On Dec 17, 2007 3:18 PM, Fabian <[EMAIL PROTECTED]> wrote:
>
> Hi is it posible to define the $conditions inside a function instead
> on the beginning of the controller. I have the following
>
> <?php
> class EventsController extends AppController {
> var $conditions = array();
>
> function encrypt() {
> $conditions = array("date_added" => "BETWEEN 2007-11-01 AND
> 2007-11-02");
> $this->set('events',
> $this->Event->findAll($this->conditions));
>
> if (isset($this->namedArgs['date']))
> {
> echo $myParam1 = $this->namedArgs['date'];
> }
>
>
> ?>
>
> I want to use the $this->namedArgs['date'] in the conditions variable,
> but right now I just wrote the static code since I'm trying to make it
> work, but when I run it the condition is ignored and it brings me all
> the records regardless of date.
>
> Is there a simpler way like in a find() where I can get records added
> a certain date?
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
