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...
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...
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...
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)? ...
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...
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(); ? ...
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...
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. ...
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...
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...
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... ...
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...
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...
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) ...
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...
I think my question would be better explained with a couple of examples... GET http://myservice/myresource/?name=xxx&country=xxxx&_page=3&_page_len=10&_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...
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...
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. ...
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...
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...