laneoc
Posts: 154
|
Posted: 05/24/2011, 12:00 PM |
|
When you use an SQL statement, you may get "...not counted" instead of the count of the grid's rows. Here's a quick and dirty way to get the count you need.
Add code such as the following in a BeforeExecuteSelect Event.
$oldSQL=$MyGridName->DataSource->SQL;
$myCountSQL="select count(*) from (".$oldSQL.") as CountTable";
$MyGridName->DataSource->CountSQL=$myCountSQL;
Change the "MyGridName" to the name of your grid. That's it.
Lane
_________________
Lane |