Displaying last records first

Results 1 to 2 of 2

Thread: Displaying last records first

  1. #1
    Redth Guest

    Default Displaying last records first

    Now i know this is probly a real easy one, but i don&#039;t know how to do it so please help me out here :-)<BR><BR>right now im using<BR>&#060;%<BR>Do While Not (objRS.EOF)<BR> <BR>response.write objRS("Name").value<BR><BR>objRS.movenext<BR><BR>L oop<BR>%&#062;<BR><BR>Now i know thats very basic, but how do i make it display the last records first? this way shows of course the oldest records first... i want to show the newest records first (highest id #)<BR><BR>Thanks in advance!<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Displaying last records first

    When you select the data ORDER BY ColumnName DESC<BR><BR>where the column name is the column based on which you want the records ordered

Posting Permissions

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