wedrowiec
Posts: 1
|
| Posted: 08/26/2005, 12:54 AM |
|
Hello.
I'm playing with CCS and I've encountered following problem. There is a grid with filter and with navigator. I start to browse data with empty filter conditions, let's say I go to page 10. Everything works cool.
Now, I add filter condition like WHERE age<30 thus narrowing record count.
The problem is, that last pagenumber is passed in URL resulting in adding to my query some LIMIT wich is far past the page count with current query... The effect is I got "no records".
Andy idea what could it be? Is it my erroneous use of the CCS or is it normal? How can I fix it?
Best regards,
Piotr
|
 |
 |
DonB
|
| Posted: 08/26/2005, 1:56 PM |
|
You must add the same filter to the ds->CountSQL property - just like you
did to the ds->SQL property. Otherwise, the grid counts pages based on the
unfiltered number of rows.
--
DonB
http://www.gotodon.com/ccbth
"wedrowiec" <wedrowiec@forum.codecharge> wrote in message
news:5430ecabb14a03@news.codecharge.com...
>
> Hello.
>
> I'm playing with CCS and I've encountered following problem. There is a
grid
> with filter and with navigator. I start to browse data with empty filter
> conditions, let's say I go to page 10. Everything works cool.
>
> Now, I add filter condition like WHERE age<30 thus narrowing record count.
>
> The problem is, that last pagenumber is passed in URL resulting in adding
to my
> query some LIMIT wich is far past the page count with current query... The
> effect is I got "no records".
>
> Andy idea what could it be? Is it my erroneous use of the CCS or is it
normal?
> How can I fix it?
>
> Best regards,
> Piotr
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Michael Mikkelsen
|
| Posted: 08/29/2005, 1:23 PM |
|
Go to the Data(tab) Properties for your search form and Set "Preserve Parameters" to "None"
|
|
|
|
Michael Mikkelsen
|
| Posted: 08/29/2005, 1:26 PM |
|
There are times when you want variables like that one to be passed from page to page and CCS makes it easy (sometimes too easy) to do.
|
|
|
|
|
