• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pagination Problems

#11
Ok, the example code makes it clearer, thank you InsiteFX.

It would appear that we're talking about different aspects of the pagination functionality... displaying an array of material from the Controller is one thing, which clearly your example does, but this wasn't my problem... my headache was in generating the (raw) content of the data records to be displayed.

In my Model, a load of geographic data is recovered for each user request (there are many (perhaps two dozen) such geographic points associated with every one of potentially tens of thousands of database records recovered in each query). The data needed to be processed and filtered according to the user's selections (each involving many calculations done on each of these individual geographic points- for example to adjust for the curvature of the earth- and which also use data recovered in sub-queries from other database tables).

Many of the recovered records from my database are thrown out in the filtering process (based on selections made by users) and the ones that remain are no longer the raw database record- I essentially end up with an array of related, but totally different data that then needed to be displayed in a paged format.

Dreaming up a query that could have been used to pull the data from the database and do all the required processing on each of the points in each of the required records and then throw out the ones that don’t match the criteria after the processing (the stage shown in your example’s Model code) in such a manner that it could be used in a chained query looked like a pretty tall order to me (perhaps impossible ?)... which is why I was trying to display and paginate an array of (custom) data.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.