Re: How to pagine a custom sql statement?

http://book.cakephp.org/view/1237/Custom-Query-Pagination explains how to implement custom pagination logic.

On Thu, Sep 29, 2011 at 12:55 AM, heohni <heidi.anselstetter@consultingteam.de> wrote:

Hi,

I have to use a own sql statement:
$results = $this->Bookmark->query('
           SELECT
               DISTINCT OBJ_NUMMER
           FROM
               Gesamtobjekt
           WHERE obj_id IN ($variableIDs) AND eia_id IN (SELECT
les_fkid_eia_id FROM Link_eia_static)
       ');

Is there any way, how to use the pagination function for this?

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php