Fred Y
|
| Posted: 03/28/2002, 5:25 PM |
|
I want to have the order sequence for a grid display by product name then by a sequence number. If I use the SQL in the form I only get one value....if I write my own sql statement does it have to be for the whole selection for the grid...including the passed parameter selections. Or is there another easier way to sort the displayed grid.
|
|
|
 |
Nicole
|
| Posted: 03/29/2002, 1:14 AM |
|
Fred,
of course you can create custom sql. In this case you can add Input parameter the same way when you select table as form source. But you should improve sql if you want to join any fields from other tables. Moreover built in sorting functionality is disabled with custom sql and you should put custom code to Open event to be able to sort (use the code similar to generated by CC).
I think the most easy way is to select sorting field on SQL tab and in Open event add second sorting field to sOrder var. E.g.
for ASP
sOrder = sOrder & " , number ASC"
for PHP
$sOrder .= " , number ASC";
|
|
|
|
|
