Ordering in reverse

Results 1 to 2 of 2

Thread: Ordering in reverse

  1. #1
    James McIntosh Guest

    Default Ordering in reverse

    I was wondering if there was a way to order thigs in reverse other than the rsDB.movelast and rsDB.moveprevious commands<BR>I am showing then 3 records at a time and when I loop backwards if there are 4 pages the 1st only has 1 and the 2nd has 3, but fine when it loops forward (3,1)<BR><BR>Is there a way to order them in reverse in the SQL statement using the ORDER BY command<BR><BR>I have all the records ordered by a numerical ID and I want to records with the highest numbers showed first<BR><BR>Any suggestions?

  2. #2
    Kasper Guest

    Default RE: Ordering in reverse

    Proper sql syntax : ORDER BY field ASC or ORDER BY field DESC<BR>for respectively ordering the &#039;field&#039; ascending or descending<BR>Does this accomplish what you intended?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts