SORTING WITH MSQUERY

syrov_andrei · Post by **syrov_andrei** » Mon 09 Jan 2006 07:26

I am want to perform sorting with MSQuery, I know list of Fields of MSQuery for sorting
and rule for sorting for each item of this list(rule - ASC or DESC). What I must doing to do this ?
Sorry , I solve this problem with using SetOrderBy method with Parameter for example '1 ASC, 2 DESC ' when 1 and 2 - number of Filed for sorting

Ikar · Post by **Ikar** » Tue 10 Jan 2006 10:52

You can perform sorting on server side by adding ORDER BY clause to SQL statement. As alternative you can use IndexFieldNames property to perform sorting on client side.