ADO sort of SQL database

Results 1 to 2 of 2

Thread: ADO sort of SQL database

  1. #1
    Join Date
    Dec 1969

    Default ADO sort of SQL database

    I have a page for the web masters that lists all users in the database. It shows their last login date. Is there a way to sort that data on the way out on the LastLogin Date Field? I would like to display the list in the order of the people who have logged on last to be at the top of the list and the users who never log on to show up on the bottom of the list.<BR><BR>TIA

  2. #2
    Mike Yang Guest

    Default RE: ADO sort of SQL database

    select * from tbl_name order by UserID DESC

Posting Permissions

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