Display items in MY order

Results 1 to 3 of 3

Thread: Display items in MY order

  1. #1
    Join Date
    Dec 1969

    Default Display items in MY order

    Is there a way I can display a list from a record set in the order that I want? I have 2 fields in my table for PDF&#039;s, one is called pdftype, one is called grouping. Depending on the pdftype, the grouping may be months (January, February, March...). I am using a SELECT DISTINCT SQL statement to grab all the distinct "grouping"&#039;s which in this case, is months. Then I use a <BR>&#060;% While Not rs.EOF<BR> <BR>rs.MoveNext<BR>Wend %&#062;<BR><BR>to spew them onto a page for a menu. When they click on the grouping (January in this case), the contents of that grouping will then be displayed.<BR><BR>Right now when I do my WHILE NOT loop, it grabs them in alphabetical order. April, August, December.. so on and so forth. Is there a way I can display January first, then February, then March...etc.?<BR><BR>Thanks,<BR>-ferretworks

  2. #2
    Join Date
    Dec 1969

    Default months

    Think in terms of Month<BR>Returns a whole number between 1 and 12, inclusive, representing the month of the year.<BR><BR>Syntax<BR>Month(date)<BR><BR>The date argument is any expression that can represent a date. If date contains Null, Null is returned.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default You might have to...

    ...construct a valid date to get that to work.<BR><BR>... Month(monthField & " 1, 2001") ...<BR><BR>Exact syntax will depend on what DB you are using.<BR><BR>

Posting Permissions

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