Well, trying to get my head round nested AND & OR queries when they
are specified as arrays is just too much for the goat cheese inside my
cranium.
There are so many instances like this where documentation is poor and
the universal answer is: "Well, read the API" or as Mario said at the
beginning
leo, I hear what you're saying but I disagree in this case. The array-
based syntax for creating complex where conditions is the bomb! Sure,
the "LIKE" clause is a little unique, but once you learn it, it's no
big deal. I particularly like that you can avoid writing "IN" clauses
by doing this:
$a
Seems to me that there are times when frameworks just make things more
complicated and open to error. If a core developer can get it wrong,
what chance do mere mortals stand? The whole array/SQL segment is not
what I would describe as intuitive.
On 29 Juny, 18:44, NOSLOW <[EMAIL PROTECTED]> wrote
Just for the record (and to possibly save others from grief if they're
trying to do a LIKE in 1.2 RCx based on this example), it should be:
$conditions = array("or"=>(array(
'edifici LIKE ?' => "%$searchText%",
'adreca LIKE ?' => "%$searchText%"
)));
I'm sure Mariano just typed
Where do I find the release notes? Daft question I know, but I can't
find any for the current release.
On Jun 16, 5:19 pm, Mariano Iglesias <[EMAIL PROTECTED]>
wrote:
> Please read the release notes regarding LIKE and other SQL operators.
> That should be:
>
> $conditions = array("or"=>(array(
>
Thanks, I'll try that.
On Jun 16, 5:19 pm, Mariano Iglesias <[EMAIL PROTECTED]>
wrote:
> Please read the release notes regarding LIKE and other SQL operators.
> That should be:
>
> $conditions = array("or"=>(array(
> 'edifici LIKE %?%' => $searchText,
> 'adreca LIKE %?%' => $sear
Please read the release notes regarding LIKE and other SQL operators.
That should be:
$conditions = array("or"=>(array(
'edifici LIKE %?%' => $searchText,
'adreca LIKE %?%' => $searchText
)));
On Mon, 2008-06-16 at 03:07 -0700, leo wrote:
> Call me a misery, but I seem to be hav
Call me a misery, but I seem to be having more problems with RC1 than
I had with Beta.
The following works as expected in Beta but invariably returns an
empty set in RC1:
$conditions = array("or"=>(array('edifici' => 'LIKE %'.
$searchText.'%', 'adreca' => 'LIKE %'.$searchText.'%')));
$this->set(
