Multi-Columns Sort with User SQL

gridsortup1 CustomerID gridsortdn1 gridsortup0 OrderID gridsortdn0 gridsortup2 EmployeeID gridsortdn2 gridsortup3 OrderDate gridsortdn3 RequiredDate
ALFKI 10702 4 11/13/1995 12:00:00 AM 12/25/1995 12:00:00 AM
ALFKI 10835 1 2/15/1996 12:00:00 AM 3/14/1996 12:00:00 AM
ALFKI 10952 1 4/15/1996 12:00:00 AM 5/27/1996 12:00:00 AM
ALFKI 11011 3 5/9/1996 12:00:00 AM 6/6/1996 12:00:00 AM
ANATR 10625 3 9/8/1995 12:00:00 AM 10/6/1995 12:00:00 AM
ANATR 10759 3 12/29/1995 12:00:00 AM 1/26/1996 12:00:00 AM
ANATR 10926 4 4/3/1996 12:00:00 AM 5/1/1996 12:00:00 AM
ANTON 10507 7 5/16/1995 12:00:00 AM 6/13/1995 12:00:00 AM
ANTON 10535 4 6/13/1995 12:00:00 AM 7/11/1995 12:00:00 AM
ANTON 10573 7 7/20/1995 12:00:00 AM 8/17/1995 12:00:00 AM

bottom next goreload

[1 - 10 : 572 Order By : CustomerID OrderID ]

User Controlled ColSortSQL
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim CS As New Tornado.z
  With CS
    .dbQP = "U=12| S=17|Gdf=0,1,2,3,4|Sf=0,1,2,3|Isc=2,1|Sclj=t|ps=10| D=Nwind| Q=Orders| Th=tit=Multi-Columns Sort with User SQL"
    .dbColSortSQL = "SELECT * FROM Orders WHERE Freight > 0 ORDER BY [[Col]]"
    .ASPdbNET()
  End With
End Sub
</script>

Send comments on this topic.
Copyright (c) 1998-2006 ASP-db