Jeff Swanson
|
| Posted: 08/02/2002, 5:46 AM |
|
I want to be able to sort the colums in a grid so that there is the primary sort and then the secondary sort. i.e. Column one sorts by the racing 'class' and then also sort by race number. So all the classes are together and then within those classes, all race numbers are together. How do I do this without writing a custom sql statement? I want to be able to leave the ability to resort via the column headers.
|
|
|
 |
Nicole
|
| Posted: 08/05/2002, 6:55 AM |
|
Jeff,
- CC solution
you can add secondary sort code to sOrder variable (that stores the sort order) in form Open event. Here is PHP example:
$sOrder .=", race_number ASC";
or
$sOrder .=", race_number ". $Direction;
- CCS solution
create Before Build Select event in order to create additional sorting. PHP example:
global $page_name;
$page_name->ds->Order .= ", race_number DESC";
|
|
|
|
Jeff Swanson
|
| Posted: 08/05/2002, 7:31 PM |
|
Perfect, this worked. Thanks.
|
|
|
|
|
