Newbie- Sort by date?

Results 1 to 3 of 3

Thread: Newbie- Sort by date?

  1. #1
    Merlin Calhoun Guest

    Default Newbie- Sort by date?

    I am new to asp and am trying to connect to an access db and then get only the Newest(date)recordset from the db? Thank's for any help.

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

    Default RE: Newbie- Sort by date?

    see what ORDER BY can do for you.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Newbie- Sort by date?

    sql = "SELECT SHOW_DATES, VENUE, SUMMARY FROM SHOWS WHERE " _<BR> & "LOGIN_ID = &#039;" & loginid & "&#039; AND SHOW_DATES &#062;= &#039;" & currentdate & "&#039; ORDER BY SHOW_DATES ASC"<BR><BR><BR>This is a sql statement to show all records for today and in the future

Posting Permissions

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