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 this off the cuff, as he's a core
> developer and really knows his stuff ;)
>
> The other way yields a SQL statement with single quotes around the
> search term insided the percent signs (e.g. " LIKE %'my search
> phrase'% "), which generates a SQL error.
>
> BTW, checking the test cases in the core is very helpful in finding
> examples to go by.
>
> On Jun 16, 11:19 am, Mariano Iglesias <[EMAIL PROTECTED]>
> wrote:
>
> > Please read the release notes regardingLIKEand other SQL operators.
> > That should be:
>
> > $conditions= array("or"=>(array(
> > 'edificiLIKE%?%' => $searchText,
> > 'adrecaLIKE%?%' => $searchText
> > )));
>
> > On Mon, 2008-06-16 at 03:07 -0700, leo wrote:
> > > 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('immobles', $this->paginate('Immoble',$conditions));
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
