yiling
|
| Posted: 04/29/2002, 2:23 PM |
|
Right now only one column of the table can be sorted each time. Is there a way to sort multiple columns?
Ex: Table with 5 columns. First I sort the table according to column 3. Then I want to sort column 2 and still maintain column 3's sorting.
Is this possible? Please help.
Thanks.
|
|
|
 |
Nicole
|
| Posted: 04/30/2002, 3:45 AM |
|
Hello,
- solution for CC:
in form Open event add custom value to sOrder variable, e.g.
ASP
sOrder = sOrder & ", field1 asc, field4 desc"
PHP
$sOrder .= ", field1 asc, field4 desc";
- solution for CC Studio:
click on the form, go to Properties window->Data tab and work with Data Source. At the bottom of Data Source window you'll see 'Order' field. You can enter all the required field manually or click on "..." button and build order by clause in dialog.
|
|
|
|
yiling
|
| Posted: 05/03/2002, 2:21 PM |
|
thanks nicole, but is this possible dynamically -- allowing the client to sort in any combination of orders they want?
thanks.
|
|
|
|
|
