Sorting using the OrderBy Property

[Guest]

Hi,

I have set the OrderBy with the following code:

HiPlanNames.LastUpdated DESC

That works well for just one field, but I need now to
include another field (ST) wich should be sorted in
ascending order; when I put it in after the above, it
won't do it.

HiPlanNames.LastUpdated DESC;HiPlanNames.ST

Any suggestions or ideas, please ???

 

[Marshall Barton]

Hi,

I have set the OrderBy with the following code:

HiPlanNames.LastUpdated DESC

That works well for just one field, but I need now to
include another field (ST) wich should be sorted in
ascending order; when I put it in after the above, it
won't do it.

HiPlanNames.LastUpdated DESC;HiPlanNames.ST

A semicolon indicates the end of an SQL statement, use a
comma to separate the two fields.