Professional Web Applications Themes

Help With SQL Statement !! - ASP Database

Is their a way i can group a bunch of records by their 'Type' And Order these records within each group by their category. I am using Jet Sql "Access". This is what i have so far.. rs.Open "SELECT Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type FROM seminar Group By Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type",cn 'Want to order by category within each group. Thanx to all those who view this post. AK...

  1. #1

    Default Help With SQL Statement !!

    Is their a way i can group a bunch of records by their 'Type' And Order
    these records within each group by their category. I am using Jet Sql
    "Access".

    This is what i have so far..

    rs.Open "SELECT
    Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type FROM
    seminar Group By
    Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type",cn

    'Want to order by category within each group.


    Thanx to all those who view this post.

    AK


    Adam Knight Guest

  2. #2

    Default Re: Help With SQL Statement !!

    ORDER BY field1 [ASC | DESC]

    Use ASC for ascending (the default) or DESC for descending. ORDER BY goes
    after GROUP BY ...

    Cheers
    Ken

    "Adam Knight" <aj.knightoptusnet.com.au> wrote in message
    news:eFDft8YhDHA.452TK2MSFTNGP12.phx.gbl...
    : Is their a way i can group a bunch of records by their 'Type' And Order
    : these records within each group by their category. I am using Jet Sql
    : "Access".
    :
    : This is what i have so far..
    :
    : rs.Open "SELECT
    : Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type FROM
    : seminar Group By
    : Seminar_Id,Seminar_Category,Seminar_Title,Seminar_ Venue,Seminar_Type",cn
    :
    : 'Want to order by category within each group.
    :
    :
    : Thanx to all those who view this post.
    :
    : AK
    :
    :


    Ken Schaefer Guest

Similar Threads

  1. help on SQL statement
    By filippo2991@virgilio.it in forum MySQL
    Replies: 2
    Last Post: June 9th, 01:13 PM
  2. [PHP] SQL statement
    By Chris W. Parker in forum PHP Development
    Replies: 14
    Last Post: September 28th, 03:48 PM
  3. if statement with url
    By John in forum PHP Development
    Replies: 5
    Last Post: September 11th, 03:13 AM
  4. if statement
    By alexz in forum ASP
    Replies: 8
    Last Post: July 15th, 04:57 PM
  5. Can i say OR in an if/then statement
    By crispy in forum ASP
    Replies: 6
    Last Post: July 9th, 07:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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