Thanks,
it works in CR1 but not with pagination. First page is OK but the next
is empty because the query is different:
first page is OK:
2 SELECT COUNT(*) AS `count` FROM `elilibs` AS `Elilib` WHERE
`Elilib`.`nazev` LIKE CONVERT( _utf8 '%74AC1%' USING ASCII)
3 SELECT `Elilib`.`id`, `Elilib`.`nazev`, `Elilib`.`pouzdro`,
`Elilib`.`sirka`, `Elilib`.`vyska`, `Elilib`.`knihovna` FROM `elilibs`
AS `Elilib` WHERE `Elilib`.`nazev` LIKE CONVERT( _utf8 '%74AC1%' USING
ASCII) ORDER BY `Elilib`.`nazev` asc LIMIT 50
second page:
2 SELECT COUNT(*) AS `count` FROM `elilibs` AS `Elilib` WHERE
`Elilib`.`nazev` LIKE CONVERT( _utf8 '' USING ASCII)
3 SELECT `Elilib`.`id`, `Elilib`.`nazev`, `Elilib`.`pouzdro`,
`Elilib`.`sirka`, `Elilib`.`vyska`, `Elilib`.`knihovna` FROM `elilibs`
AS `Elilib` WHERE `Elilib`.`nazev` LIKE CONVERT( _utf8 '' USING ASCII)
ORDER BY `Elilib`.`nazev` asc LIMIT 50
I do know I am getting boring but I didn't find how to insert my
condition to next pages.
On 4 Čen, 20:27, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote:
> > Thanks for your help, but using -! didn't help much. Cakephp wrongly
> > inserted a = before the LIKE.
>
> Then if you are using a version from SVN,
>
> $cond=array("Elilib.nazev LIKE"=> "-! CONVERT( _utf8
> "."'".$this->data['Elilib']['nazev']."' USING ASCII)");
>
> Regards,
> - Dardo Sordi.
>
> > = LIKE CONVERT( _utf8 '%74%' USING ASCII)
>
> > Regards
>
> > Igor
>
> > Dardo Sordi Bogado wrote:
>
> >>> It's wrong and I don't get any data. Is it a bug in cakephp or I a am
> >>> doing something wrong?
>
> >> Cake is escaping your data, prepend "-!" to the condition.
>
> >> $cond=array("Elilib.nazev"=> "-! LIKE CONVERT( _utf8
> >> "."'".$this->data['Elilib']['nazev']."' USING ASCII)");
>
> >> HTH,
> >> - Dardo Sordi.
>
> > --
> > View this message in
> > context:http://www.nabble.com/LIKE-operator-with-a-function-tp17631202p176496...
> > Sent from the CakePHP mailing list archive at Nabble.com.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
