pagination

Database design: Splitting a blog entry into multiple pages

What is the best database strategy for paginating a blog entry or page content where some entries may be a single page and some may span multiple pages? Note: The content would be article-like rather than a list of items. The method that I'm currently considering is storing all of the content in a single text field and using a page sepa...

Pagination in Joomla!

Hi every one. I'm a bit new to Joomla! and I'm building my new web site using Joomla! 1.5.8 with a template bought from RocketTheme. The long article in question is a gallery of photos, and I wanted to create a horizontal pagination nav-bar in the footer of the gallery, I just clicked pagebreak where I wanted to paginate in my article i...

Paginated search results with LINQ to SQL

What's the best pattern to get paginated results with LINQ to SQL? I have the following scenario: Suppose I want to search items table by description. I can easily do: public IQueryable<Item> FindItemsByDescription(string description) { return from item in _dc.Items where item.Description.Contains(description); } Now, w...

Best way to implement an "endless page" in rails?

Pagination sucks! The user should be able to scroll down forever, automatically pulling in new content when appropriate. There's a decent rails cast about this, but Ryan admits that his solution won't work in IE. What's the best way to accomplish this in Rails (preferably in a jQuery-friendly fashion)? ...

MySQL pagination without double-querying?

Hi all, I was wondering if there was a way to get the number of results from a MySQL query, and at the same time limit the results. The way pagination works (as I understand it), first I do something like query = SELECT COUNT(*) FROM `table` WHERE `some_condition` After I get the num_rows(query), I have the number of results. But th...

How do I display the result of this query using Joomla pagination?

What can I do to display the result of this query in the fronted using the Joomla pagination? <?php $database =& JFactory::getDBO(); $sql = 'SELECT * FROM #__no_entreprise'; $database->setQuery( $sql ); $rows = $database->loadObjectList(); ? ...

onBecomesVisible in Javascript for clickless pagination?

is there any javascript library that provides me with a custom event as soon as a certain element becomes visible in the browser canvas? the basic idea is, as soon as the last element in a list becomes visible on the screen, i want to load the next 10 elements so that the user does not need to click on the "next page" button. to achiev...

Rails, ActiveResource, and Pagination

What's the best way to implement pagination in a REST API so that an ActiveResource client can easily navigate paginated results? There have been some proposals, for example here and here, but being new to ActiveResource I'm wondering if there's a better way. ...

Paging in GridView using SqlDataSource

I have a GridView that accesses data from a SqlDataSource in DataSet mode. I have paging enabled and it works, but on large datasets it takes an extraordinarily long time to pull data. It seems like the SqlDatSource is pulling all the data, and then it's being paged at the UI level. This is obviously a lousy solution. I've looked at htt...

yui and server-side pagination

I'm using YUI 2.7.0, and I've gotten the client-side pagination down, and am now trying to get the server-side pagination down (The query could possibly return thousands of results). Right now, no results are being shown (I get the "No records found." message). Can't seem to find an answer on the web. The call to alert() shows the correc...

Asp.Net pagination best practice

I'm using linq to sql to get my data, when I set the page size on my data grid and the user selects page 2, I get a postback and I re-read all the data to show the second page. I suspect there should be a better way of doing this, a way that ends up reading just the data I need to show. I was wondering if there are any code samples... ...

Paging on a Random Items Data Set

I have to generate a list of items on a website which are random for the session of the user for that particular list of items. I am going to add a link to demonstrate the problem. WebSite Link Scenario: When a user comes in and clicks on the link, the items on the page should be randomized. As the user clicks on page two, three on...

Page results in [database of your choice]

I'd like to collect the "state of the art" ways to paginate results for any database in this wiki. Input: I have a huge table PAGE_ME: create table PAGE_ME ( ID bigint not null, NAME varchar(32) not null, CREATED TIMESTAMP not null ) id is not necessarily in the same order as created. I want to display the results between...

Pagination is not working after search form is submitted and result is shown

Hi, I'm developing a portlet by using Spring. In one of my JSPs I have a form where user can input search parameters ans submit. Both formView and successView is configured to be the same JSP page. In that page, I have a displayTag to render the result. Everything is ok except pagination of the list.My controller(SimpleFormController) ...

Paging in a Rest Collection

I'm interested in exposing a direct REST interface to collections of JSON documents (think CouchDB or Persevere). The problem I'm running into is how to handle the GET operation on the collection root if the collection is large. As an example pretend I'm exposing StackOverflow's Questions table where each row is exposed as a document (n...

standard way of encoding pagination info on a restful url get?

I think my question would be better explained with a couple of examples... GET http://myservice/myresource/?name=xxx&amp;country=xxxx&amp;_page=3&amp;_page_len=10&amp;_order=name asc that is, on the one hand I have conditions ( name=xxx&country=xxxx ) and on the other hand I have parameters affecting the query ( _page=3&_page_len=10&_o...

Advanced report generation library

Anyone know of a reporting library for Delphi Win32 (or possibly in C#/.Net, Java) that provides the following types of features in a page formatting mode (I am not looking for a banded report writer). This is not an exhaustive list, merely some of the key areas of interest. Tables Column and row spanning Rich formatted content in ce...

Client-side pagination with jqGrid

I know it's possible to do client-side sorting in jqGrid by setting loadonce = true but is it possible to do client-side paging as well? I want to pass all the data (about 80 pages of JSON) to the client initially during page load and then, I don't want any server calls. I want jqGrid to handle both the paging and sorting. ...

jQuery Pagination from Given Records ID

Hi all, I have found many pagination coding for jQuery plugin. Everything is working fine. But my need is, i have 20 records in table.I want to display only one records at a time with First - Previous - Next - Last . when i enter particular Records Id like '15', It should show that details of 15 , and if i click next it show next R...

DataGridView, ADO.NET, Binding, and Paging on the Client

I'm working on a WinForm application that has several queries that bring back approx 20000 records and then fills a DataTable, and binds that DataTable to a DataGridView. I want to allow the users to page through the grid 500 records at a time. What is the best way to do this? I want to do the paging on the client side. I see that the S...