How to pagine a custom sql statement?

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