Seems like the cool -! trick is no longer supported, you need to do
$this->query now to make it work.
Cheers,
mbavio
On Jun 12, 3:48 pm, igorp <[EMAIL PROTECTED]> wrote:
> Of course ... being involved in projects with micros all the time I
> forgot about the HTML protocol ... Thank for your kick.
> Including a condition to "next" and "prev" url solved my problem.
> My last question. Using "-!" in a query i am getting an annoying
> warning
> Warning (512): Escape flag (-!) deprecated, use Model::query() [CORE/
> cake/libs/model/datasources/dbo_source.php, line
> Is it any way how to avoid the warning in pagination?
>
> Regards Igor
>
> On 9 Čen, 01:00, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote:
>
> > From where are you obtainig the parameters for the query?
>
> > If from the URL, put this at the top of the view
> > $paginator->options(array('url' => $this->params['pass']));
>
> > 2008/6/8 igorp <[EMAIL PROTECTED]>:
>
> > > 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`LIKECONVERT( _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`LIKECONVERT( _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`LIKECONVERT( _utf8 '' USING ASCII)
> > > 3 SELECT `Elilib`.`id`, `Elilib`.`nazev`, `Elilib`.`pouzdro`,
> > > `Elilib`.`sirka`, `Elilib`.`vyska`, `Elilib`.`knihovna` FROM `elilibs`
> > > AS `Elilib` WHERE `Elilib`.`nazev`LIKECONVERT( _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 theLIKE.
>
> > >> Then if you are using a version from SVN,
>
> > >> $cond=array("Elilib.nazevLIKE"=> "-! CONVERT( _utf8
> > >> "."'".$this->data['Elilib']['nazev']."' USING ASCII)");
>
> > >> Regards,
> > >> - Dardo Sordi.
>
> > >> > =LIKECONVERT( _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"=> "-!LIKECONVERT( _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
-~----------~----~----~----~------~----~------~--~---
