Forums

hi,
how can i set/see/make a pagnation for a dbreader in cf5?

thx
Brani

Hi Brani,

There is nothing built in in ChronoForms to do this - you could probably code it manually but if the list is long enough to need pagination I suggest that you look at ChronoConnectivity which is built to cleate listings.

Bob

ok thx. can you give me a tip how i can set a Limit in a Multi dB Reader?

Hi Brani,

I don't' think that you can, but you can add a MySQL query in a Custom Code action that includes a limit.

<?php
$db = JFactory::getDBO();
$query = "
    SELECT ``
        FROM `#__`
        WHERE `` = '' 
        LIMIT 999;
";
$db->setQuery($query);
$data = $db->loadObjectList();
. . .

Bob