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:
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:
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
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 this off
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.'%')));
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 having
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 %?%' = $searchText
)));
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(
