What version of Cake are you using?
I believe the BETWEEN syntax is a somewhat recent development.
On 10 Sep 2008, at 11:32, Daniel wrote:
>
> Hello everyone,
>
> I'm trying to perform a find operation on my 'event' model in order to
> retrieve "events" that fall within a specific date range. I've read
> the manual on the process to do complex find conditions but thus far
> I've been unable to get it to generate working SQL code that will
> accomplish my goal.
>
> The following is my find statement (here's to hoping the formatting
> sticks somewhat) :
>
> $events = $this->Event->find('all', array('recursive' => 1,
> 'conditions' => array(
> 'User.id' => $currUser['id'],
> 'or' => array(
> 'Event.startTime BETWEEN ? AND ?' =>
> array($bottomSearchBound,$topSearchBound),
> 'Event.endTime BETWEEN ? AND ?' =>
> array($bottomSearchBound,$topSearchBound)
> )
> )
> ));
>
> The sql it generates (snipped version) is as follows:
>
> WHERE `User`.`id` = 7 AND ((`Event`.`startTime BETWEEN ? AND ?` IN
> ('2008-08-01', '2008-10-01') ) OR (`Event`.`endTime BETWEEN ? AND ?`
> IN ('2008-08-01', '2008-10-01') ))
>
> And the error it generates is:
>
> Warning (512): SQL Error: 1054: Unknown column 'Event.startTime
> BETWEEN ? AND ?' in 'where clause'
>
> Obviously the "?" token replacement isn't being completed
> successfully.
>
> Any help would be _greatly_ appreciated!
>
> - Daniel
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
