Results 1 to 3 of 3

Thread: Selecting Database Records

  1. Aug 21st, 2000, 09:16 AM #1
    rodders45
    rodders45 is offline

    Thread Starter
    Member
    Join Date
    Jun 2000
    Location
    Manchester, UK
    Posts
    50

    Cool

    I have an Access database with a field in called 'Category'. This field contains several records with the same value, e.g

    CATEGORY
    News
    News
    News
    Games
    News
    Games
    Games
    Games

    What I want to do is get a list of all the different category names using ASP. How do you do it?
    Reply With Quote Reply With Quote
  2. Aug 21st, 2000, 01:00 PM #2
    Nias
    Nias is offline
    Lively Member
    Join Date
    Jan 2000
    Location
    Omaha, Ne
    Posts
    65

    Arrow Distinct

    Try "Select Distinct Category FROM ..." in your query string. This should return 2 rows with NEWS and GAMES.
    That help?
    Reply With Quote Reply With Quote
  3. Aug 21st, 2000, 02:06 PM #3
    rodders45
    rodders45 is offline

    Thread Starter
    Member
    Join Date
    Jun 2000
    Location
    Manchester, UK
    Posts
    50

    Smile Thanks

    Thanks a lot!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width