On May 24, 10:21 pm, squidliberty <[EMAIL PROTECTED]> wrote:
> Fabulous! That works perfectly for most of my queries. But why won't
> it work in the following?
>
> $conditions['NOT'] = array('Listing.expiration' => "BETWEEN 1 AND
> ".mktime());
> $conditions[0]['OR'] = array("Listing.title" => "LIKE %".$term."%",
> "Listing.description" => "LIKE
> %".$term."%");
> $conditions[1]['OR'] = array("Listing.title" => "LIKE %".$term_2."%",
> "Listing.description" => "LIKE
> %".$term_2."%");
>
> Based on the examples given in other discussions, I'd expect this to
> return all listings between the timestamps given that include both
> term 1 and term 2 in either the title or description. But instead, the
> expiration requirement is ignored entirely.
What sql is that generating, and what sql do you need to get it to
work as you want.
http://www.google.com/search?q=online+sql+format + http://bin.cakephp.org
= readable output.
hth,
AD
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
