smokingguns
Posts: 51
|
| Posted: 06/09/2009, 12:50 PM |
|
Hey all,
Whenever I add a navigator to a grid, It shows me only 2 page links. These are the options I choose(I have added navigators scores of times before and this stumps me totally) when I add a navigator:
Current Page in the center and Show Total Pages. I have set the Number of page links to 10.
When I view the page in browser , here is how the navigator display the links:
1 2 of 2
On clicking page link 2, the navigator changes to this:
1 2 3 of 3. Now on clicking page link 3, it becomes:
1 2 3 4 of 4.
Its as if the links are hidden and are being uncovered.
There is 9 pages of data. Shouldnt it show all 9 page links at once??
Has anybody seen this before.
Im using CCS 4.1
|
 |
 |
Edd
Posts: 547
|
| Posted: 06/09/2009, 3:59 PM |
|
This happens when your SQL for the grid is so complicated that when CCS wraps the Select Count statement around it to build navigation its results cannot be interpreted.
2 Methods of fixing this:
1. Create a view of the SQL statement in the database then reference the view.(my preference)
2. Generate your own Count statement
Cheers - Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
smokingguns
Posts: 51
|
| Posted: 06/10/2009, 7:11 AM |
|
Thanks Edd,
That solved the problem. CCS never generated the Count SQL.
|
|
|
|
tcb
Posts: 34
|
| Posted: 08/06/2009, 1:21 PM |
|
I just ran into this and ended up making a View.
Is there a publicly available Bug List and is this in it?
|
|
|
|
|
