Pagination and initial records per page

broberts 09 Sep, 2008

The first time a page is displayed using {pagination} All is the default which causes all data to be displayed. Is there any way to specify an initial default # of records per page for this display?

Max_admin 09 Sep, 2008

Hi,
I agree, I'm applying some enhancements to ChronoConnectivity today and this one should be from them, I will let you know, drop me a message here if I forgot to update you!

Regards

Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

ah

ahannover 12 Nov, 2008

Hi
I have the same concerns. I want to limit the result page to the first 25 rows. {pagination}
Is this possible now? I cant find any setting for the default pagination.
Best regards
Anders

Max_admin 12 Nov, 2008

Hi Anders,

in your global joomla config you can set the default pagination count which will be used!

Regards
Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

ah

ahannover 13 Nov, 2008

Do you mean the list length parameter?.
It's set to 20 but that is not reflected when looking at the chronoconnectivity output. It always default to all. (and my table contains many rows!)
Could it be caused by theme? It works in all other components/modules.
I use commercial theme Versatility III from rockettheme.com in front-end.
If I manually change it to 25 it will remember the setting until session times out or I restart browser.
If I add {pagination} to the header I cant change the setting at all. If I change it to let's say 45, it will reset back to 25 again.
I add {pagination} just before the first table definition in the header. Then it completely stops working.

HEADER

<html>
<head>
  <meta http-equiv="content-type"
 content="text/html; charset=ISO-8859-1">
  <title></title>
</head>
<body>
<h2 dir="ltr"><a href="index.php?option=com_chronoconnectivity&Itemid=84"><img style="vertical-align: middle;" alt="refresh" src="images/stories/refreshbutton.gif" width="65" height="52" /></a> This is the IT Operation production event log   <a href="index.php?option=com_chronocontact&Itemid=83"><img style="vertical-align: middle;" alt="add" src="images/stories/add_button.gif" width="50" height="20" /></a></h2>
<table
 style="text-align: left; width: 100%;"
 border="0" cellpadding="2" cellspacing="0">
  <tbody>
    <tr style="background-color: rgb(204, 204, 204)";>
      <td style="font-weight: bold; width: 3%;">ID# </td>
      <td style="font-weight: bold; width: 7%;">Date           </td>
      <td style="font-weight: bold; width: 4%;">Time  </td>
      <td style="font-weight: bold; width: 21%;">Device/Server/System</td>
      <td style="font-weight: bold; width: 15%;">Customers
affected</td>
      <td style="font-weight: bold; width: 40%;">Action</td>
      <td style="font-weight: bold; width: 10%;">Name of
implementor</td>
    </tr>
  </tbody>
</table>
</body>
</html>

<?php
$i = 0;
?>

BODY

<table style="text-align: left; width: 100%;" border="0"
 cellpadding="2" cellspacing="0">
  <tbody>
    <tr<?php if ($i % 2) echo ' style="background-color: #EBEBEB;"';?>>
      <td style="font-weight: bold; width: 3%;">{cf_id}</td>
      <td style="font-weight: bold; width: 7%;">{date_0}</td>
      <td style="font-weight: bold; width: 4%;">{time_1}</td>
      <td style="font-weight: bold; width: 21%;">{system_1}</td>
      <td style="font-weight: bold; width: 15%;">{customer_1}</td>
      <td style="font-weight: bold; width: 40%;">{action_1}</td>
      <td style="font-weight: bold; width: 10%;">{name_1}</td>
    </tr>
  </tbody>
</table>
<?php $i++ ?>

FOOTER

<br>
End of list
<br>
{pagination}

Max_admin 13 Nov, 2008

Hi, I'm attaching 2 patches for 2 files which will add and use a new setting for the list limit!😉

Regards
Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

ah

ahannover 14 Nov, 2008

Hi
Tried it and it introduced a new problem.
After adding chronoconnectivity.php in joomla/components/com_chronoconnectivity I got this error message when trying to view the data.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=SELECT count(*) FROMYou are not allowed to access this page!

After restoring to original chronoconnectivity.php file, the error went away.
(I added administrator file first without error and I still have it in there. Should I back out this file too?)
So I currently do not know if it solved my pagination problem or not ;-)
Best regards
Anders

Max_admin 14 Nov, 2008

Hi, you get the error when trying to view the data on frontend or admin area ?

Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

Max_admin 15 Nov, 2008

i made some fix here:
http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=12&t=11562&p=17172#p17172

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

ah

ahannover 19 Nov, 2008

Hi Max
Just to be sure that I'm doing this correctly.
Which version of Chronoconnectivity does this fix apply to. 1.1 or 1.2?
Best regards
Anders

Max_admin 19 Nov, 2008

Hi Andres,

To 1.2😉

Regards
Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

jm

jmauver 19 Mar, 2009

Hi Max,

I am having the same issue: All the records being displayed on initial page. I would like to restrict to 10 per page. I did install the patches you posted in this thread, but I can not see where I can change the number of records for the initial page display. Is it supposed to have a text box when editing the connection where you enter a value ? I just can not find it. Or it is somewhere else ?

Thanks a lot,

Jmauver

Al

AltPower 09 Sep, 2009

I am having the same issue: All the records being displayed on initial page. I would like to restrict to 10 per page. I did install the patches you posted in this thread, but I can not see where I can change the number of records for the initial page display. Is it supposed to have a text box when editing the connection where you enter a value ? I just can not find it. Or it is somewhere else ?

same problem😟 If anybody knows the solution, please post it here

Gr

GreyHead 17 Sep, 2009

Hi altpower,

You need to put 10 into the 'List Limit' box.

Bob

ta

tamarteleco 27 May, 2010

Hi,
My display Num is not working.

In error console appears:

this.form is null

Do I miss sth?

Thanks

Gr

GreyHead 27 May, 2010

Hi tamartelco,

Have you enabled the 'Form tags' in the set up?

Bob

ta

tamarteleco 27 May, 2010

No 😲
Now is working!!

Thanks again!

Check the new Joomla Extension Builder

Pagination and initial records per page