Koren
Posts: 83
|
| Posted: 03/11/2007, 1:36 PM |
|
Can I remove the CCS "SELECT COUNT(*) FROM..." on my grids in a couple of pages?
I see that I can comment them out in the filename.php page, but I hate to mess with the auto genterated code if at all possible.
FYI: the reason I need to remove them is because I am using custom SQL to generate the statements to render the grids and it doesn't alter the SELECT COUNT which, in turn, produces "Database Error: Unknown table " errors.
|
 |
 |
ejay
Posts: 17
|
| Posted: 03/12/2007, 12:51 AM |
|
suppose you grid is named "mygrid"
in your php program, just where you define your custom sql, like this : $mygrid->datasource->SQL="select custom sql...";
add another line that defines a custom sql to count records, like this:
$mygrid->datasource->CountSQL="your custom sql that counts records";
_________________
Eric Jay
web solutions using CodeCharge studio |
|
|
|
|
