Grid not paging

[dshieh]

Using forums.js to help me get started using the Grid component, I am nonetheless not able to get paging to work. I have set page size to 10, whereas the total row count is 25. So, the grid toolbar correctly shows three pages. However, all 25 records are shown at once. Clicking on the paging buttons doesn't appear to do anything, since all 25 records are showing anyways.

Here is the relevant portion of my code:

sm = new YAHOO.ext.grid.SingleSelectionModel();
sm.addListener('selectionchange', onSelection);
            
cm = new YAHOO.ext.grid.DefaultColumnModel([
	{header: "ID", width: 40}, 
	{header: "Item", width: 100}, 
	{header: "Value", width: 100}
]);
cm.defaultSortable = true;
    		
dm = new YAHOO.ext.grid.XMLDataModel({
	tagName: 'TestTable',
	id: 'pID',
	fields: ['pID', 'testItem', 'testValue']
});
dm.initPaging(url, 10);
dm.baseParams = {'keyword': keyword};
			
dm.getTotalRowCount = function()
{
	return 25;
}

dm.setDefaultSort(cm, 0, 'ASC');
            
grid = new YAHOO.ext.grid.Grid('target-results-grid', dm, cm, sm);
grid.render();
            
var toolbar = grid.getView().getPageToolbar();
            
dm.loadPage(1);

[jack.slocum]

Paging is done on the server. If you send 25 records back it will show 25 records.

FYI, when choosing which forum to post in, lean toward "Help" not "Bugs" unless you are certain it's a bug.

[dshieh]

Thanks, Jack, for the assistance. I realized that I probably should've posted in Help a bit too late.

Regarding paging being performed on the server side, I'm a bit confused. Looking at topics.php, it looks like all records are returned all at once. However, the grid in forum.js shows only 20 records per page, which is how the grid is defined. So, where exactly is your recordset being limited to 20 records at a time?

Paging is done on the server. If you send 25 records back it will show 25 records.

FYI, when choosing which forum to post in, lean toward "Help" not "Bugs" unless you are certain it's a bug.

[jack.slocum]

On the server. When topics.php is called, it is passed a page number and a pageSize. So if page is 3 and pageSize is 20, it will return records 41-60. This way you can work with a large recordset without loading all the records at once.

[dshieh]

Okay. But, I don't see where (in forum.js) this is hooked up to the paging buttons on the grid's paging toolbar.

On the server. When topics.php is called, it is passed a page number and a pageSize.

[tryanDLS]

It's in the onClick in PagedGridView which is handling the default paging process

[jack.slocum]

I'd recommend reading this post:

http://www.jackslocum.com/blog/2006/...e-of-the-grid/

[dshieh]

Thanks, Jack, for the recommendation. That has been the post I've been using to familiarize myself with the Grid component. I had missed:

By default the model appends the following parameters to paging and sorting requests: page, pageSize, sortColumn and sortDir.

under your description of paramMap. Armed with that information and a modification of my database query on the server, I've gotten paging to work successfully. Thanks for your help, Jack.

I'd recommend reading this post:

http://www.jackslocum.com/blog/2006/...e-of-the-grid/