Sorting and subsorting recordset

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Sorting and subsorting recordset

    DMX 2004
    MSSQL 2000
    ASP/vbScript

    I want to sort a by a field and then by another within that fielld. Sort by
    Model and sort models by year. i.e 2004 Acura, 2002, 2003 BMW, 2001 Bmw...
    How can this be done?


    Armen Guest

  2. Similar Questions and Discussions

    1. Sorting array vs sorting paginated array
      ....pulling in a long list of photos in a gallery, and I have a sort function working within the pages of data fine. I need to bring it back out of...
    2. Sorting recordset with 'index' letters
      Hi I am trying to create a recordset where the results are sorted into alphabetical order but also where an index letter is included at the top...
    3. RecordSet.Move or RecordSet.AbsolutePosition??
      Hi, I'm trying to use either one of these methods to position the cursor in a specific position inside a recordset, but neither one seems to...
    4. Help with sorting... please.. :)
      I'm trying to sort the output of a query.. and I know you can use the "order by" clause, but it doesn't work the way I want it to. I'm trying to...
    5. Sorting in SQL
      ORDER BY CASE WHEN ISNUMERIC(client_code) = 1 THEN CAST(client_code AS INT) END, CASE WHEN ISNUMERIC(client_code) = 0 THEN client_code END ...
  3. #2

    Default Re: Sorting and subsorting recordset

    Nevermind, I figured it out:

    ORDER BY vMake, vYear ASC


    "Armen" <mardirousi@sbcglobal.net> wrote in message
    news:d6ls1d$3n1$1@forums.macromedia.com...
    > DMX 2004
    > MSSQL 2000
    > ASP/vbScript
    >
    > I want to sort a by a field and then by another within that fielld. Sort
    > by Model and sort models by year. i.e 2004 Acura, 2002, 2003 BMW, 2001
    > Bmw... How can this be done?
    >
    >

    Armen Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139