Paging with custom page views?

Talk about Sorting & Paging problems, issues etc.

Moderators: ne_moj, zewa, vadimako, ne_moj, zewa, vadimako

bradkb
Newbie
Newbie
Posts: 9
Joined: Jun 9th, '09, 18:46

Paging with custom page views?

Postby bradkb » Dec 28th, '09, 17:24

Quite a complicated query, but here goes.

On our datagrid we have custom call range buttons on the top of the page based on age ranges -
40-44, 45-49, 50-54, 55-59 etc.

Then on the page is Get callrange, and using PHP switch we do a case statement to assign the SQL statement to only show these age ranges.

However the paging at the bottom will ignore this and use the default sql statement. How can we fix this to include the callrange in the paging options?

administrator
Site Admin
Site Admin
Posts: 5990
Joined: Jan 7th, '09, 23:18
Contact:

Re: Paging with custom page views?

Postby administrator » Dec 29th, '09, 10:06

Try to make your rage to be a part of SELECT SQL statement:
For example:

SELECT
........
FROM
........
WHERE ...... 10 < age_range < 100

Bottom paging must take it on account

bradkb
Newbie
Newbie
Posts: 9
Joined: Jun 9th, '09, 18:46

Re: Paging with custom page views?

Postby bradkb » Dec 29th, '09, 19:33

Fixed! because we use GET for the callrange by adding this

viewtopic.php?f=33&t=352

fixed it!


Return to “Settings: Sorting & Paging”