CodeCharge Studio | All ASP PHP Perl ColdFusion Java C#.NET VB.NET |
This example shows how to modify the Order By clause for a Grid form. Within an SQL statement, the Order By clause determines the order in which the selected records will be sorted. In this case, we have a Tasks Grid that is based on the tasks database table which has a text field called task_name. The code below will cause the records in the Grid to be sorted by task_name in descending order.
Function Tasks_DataSource_BeforeBuildSelect(Sender) If Tasks.DataSource.Order = "" Then Tasks.DataSource.Order = "task_name DESC" End if End Function
function Tasks_DataSource_BeforeBuildSelect(& $sender) { global $Tasks; If ($Tasks->DataSource->Order == "") { $Tasks->DataSource->Order = "task_name DESC"; } }
sub Tasks_DataSource_BeforeBuildSelect() { if ($Tasks->{DataSource}->{Order} eq "") { $Tasks->{DataSource}->{Order} = "task_name DESC"; } }
<!--Tasks_BeforeBuildSelect ---> <CFIF strOrder eq ""> <CFSET strOrder= "task_name DESC"> </CFIF>
// Tasks_BeforeBuildSelect if (StringUtils.isEmpty(e.getCommand().getOrder())) { e.getCommand().setOrder("task_name DESC"); }
' Tasks_BeforeExecuteSelect If Select_.OrderBy = "" Then DirectCast(Select_,TableCommand).OrderBy = "task_name DESC" End if
// Tasks_BeforeExecuteSelect if (Select.OrderBy == "") { Select.OrderBy = "task_name DESC"; }