Pagination by alpha, 'All' fails & Search query

Hi,

Some questions with respect to pagination and searching.
1.Is it possible, are there any tools available that would allow me to make that pagination alphabetic? That is, instead of pages 1 to whatever, pages A to Z?
2. Can you suggest reasons why the 'All' option in the pagination tool should leave me with a blank page, no error messages, nothing in Firebug and literally no HTML code?
3. If I want to add a search control on a form that searches specific database values and relaods the form (a table), do I do that with ChronoConnectivity? I think I am making heavy weather looking for jQuery tools to do that for me


Regards

Nick

Hi Nick,

1.Is it possible, are there any tools available that would allow me to make that pagination alphabetic? That is, instead of pages 1 to whatever, pages A to Z?

ChronoForms use the pagination code from your templete to create the pagination block, I imagine that you could hack this to use letters but I've never seen it.

2. Can you suggest reasons why the 'All' option in the pagination tool should leave me with a blank page, no error messages, nothing in Firebug and literally no HTML code?

A completely blank page is usually an indicator of a PHP Error. Please try temporarily setting your Site Error Reporting to Maximum in the Site Global Configuration and see if you get a more helpful error message.

3. If I want to add a search control on a form that searches specific database values and relaods the form (a table), do I do that with ChronoConnectivity? I think I am making heavy weather looking for jQuery tools to do that for me

If you are using Joomla! 1.5 & CFv3 then, yes you can use ChronoConnectivity. If you are using Joomla! 1.6/1.7 then ChronoConnectivity has not been released for those versions yet. The DB Multi Record Loader action in CFv4 has most of the core functionality of CC and you can use that to build a search form.

Bob

Thanks for the very fast reply - as usual - Bob. I will look at these tomorrow. Too late (and hot) here right now!

Nick

Hi Bob,

1. I can't find the pagination block in my template - there are several on the site. Do you know where the chronoforms pagination will 'fall back to' if there isn't one in the template? The code looks just a bit hairy in each of them so I just might pass on that one in any case. I would like to have a closer look though.
2. re the blank page - I have PHP errors switched on, I have the web error log switched on. I have switched on system debugging and set the errors levels to maximum - but still no output at all. Nothing! If you think it possible/likely that it is a PHP error then I can ask my hosting provider for some assistance. If I could find the pagination code block I could perhaps track it from there.
3. I am still on J 1.5. If 'CFv4 has most of the core functionality of CC', is there any added value in using CC? I will have to switch to J1.7 or whatever later anyway. I had better nut out how to add that search to the form. Does your book cover this sort of stuff? I really should get a copy.

Regards

Nick

Hi Nick,

The default Joomla! pagination code is in libraries/joomla/html/pagination.php or can be over-ridden by templates/template_name/html/pagination.php

For the blank page - very odd, I would expect to see a PHP error; the server log may tell you something.

I'm not at all expereinced with working with the DB Multi Record Loader in CFv4 but there is a tutorial and a couple of usefult threads on the site. Max has said that he is working on ChronoConnectivity for Joomla! 1.6/1.7/2.5 but I have no idea when tha tmight be released.

The Cook book, unfortunately, was written for ChronoForms 3.1, and does not cover ChronoConnectivity. Many of the recipes in there can easily be adapted to ChronoForms v4 but the admin interface is very different.

Bob

Thanks for the info Bob. I will look into it. I had better wait for the new version of the book then.🙂

Nick

Coming back to that problem of displaying all 'records',

A completely blank page is usually an indicator of a PHP Error. Please try temporarily setting your Site Error Reporting to Maximum in the Site Global Configuration and see if you get a more helpful error message.

I have tried that with no output, Bob. No errors, nothing! And on three different browsers. I have got further in that I have deduced that I can get a display if, on the form Multi Record Loader, Data Displayer, I choose no more than 264 records. 265 I get a blank HTML page. If I then switch that 'Enable Data Displayer' on, they disappear again.

I seem to recall you mentioned some problems with templates. I will check that next but if you could help and have a look at the problem, then I will need to email you some site access information.

ps switching to the Beez template made no difference


Puzzled!

Hi Nick,

I can get a display if . . . I choose no more than 264 records. 265 I get a blank HTML page.

That sounds like a problem with server security. If suhosin is running then these three settings need to be at least 1,000 (possibly 2,000 if you use large forms).

suhosin.get.max_vars
suhosin.post.max_vars
suhosin.request.max_vars

Bob

Ah hah! I will pass that on to my hosting service and see if they have any knowledge of that. Thanks.

Nick

Not a server problem it would seem, Bob. I have tracked it down to a line of code which is odd as it works fine if you page through it. Anyway all down to me! All I have to do is to work out why!
Nick