Example for sorting on mulitple columns?

Posts   
 
    
geckoman7
User
Posts: 6
Joined: 23-Feb-2005
# Posted on: 24-Feb-2005 17:19:34   

I looking for an example on how to sort on multiple columns in a TypeList. For example, how do I do the following in LLBLGen?

SELECT OrderID, CustomerID, ShippedDate FROM Orders order by CustomerID ASC, ShippedDate DESC

Thanks!

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 25-Feb-2005 11:15:01   

geckoman7 wrote:

I looking for an example on how to sort on multiple columns in a TypeList. For example, how do I do the following in LLBLGen?

SELECT OrderID, CustomerID, ShippedDate FROM Orders order by CustomerID ASC, ShippedDate DESC

Thanks!

Please see the section "Best Practices -> How do I? -> How do I sort the fields in a typed list?" in the documentation. This explains how to sort on two fields.

Frans Bouma | Lead developer LLBLGen Pro
geckoman7
User
Posts: 6
Joined: 23-Feb-2005
# Posted on: 26-Feb-2005 00:04:14   

Thanks!