Professional Web Applications Themes

Return Records and not duplicate them :: Again - Dreamweaver AppDev

I will finish the post this time... I need help on the following situation. I have a solution in ASP/VB Script where I query a RecordSet for templates stored in it. At the moment I am getting the following results for a user Template 1 Template 1 Template 2 Template 2 Template 4 My question is how do I stop the repeat records and just display the unique records i.e. Template 1 Template 2 Template 4...

  1. #1

    Default Return Records and not duplicate them :: Again

    I will finish the post this time...

    I need help on the following situation.

    I have a solution in ASP/VB Script where I query a RecordSet for templates
    stored in it.

    At the moment I am getting the following results for a user

    Template 1
    Template 1
    Template 2
    Template 2
    Template 4

    My question is how do I stop the repeat records and just display the unique
    records i.e.

    Template 1
    Template 2
    Template 4


    The Ox Guest

  2. #2

    Default Re: Return Records and not duplicate them :: Again

    use SELECT DISTINCT instead of just SELECT

    --
    Nancy Gill
    Team Macromedia Volunteer for Dreamweaver MX/UltraDev
    [url]http://www.macromedia.com/go/team/[/url]
    Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
    Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
    Guide, Mastering Macromedia Contribute
    Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

    "The Ox" <robrob.com> wrote in message
    news:d19m19$pki$1forums.macromedia.com...
    > I will finish the post this time...
    >
    > I need help on the following situation.
    >
    > I have a solution in ASP/VB Script where I query a RecordSet for templates
    > stored in it.
    >
    > At the moment I am getting the following results for a user
    >
    > Template 1
    > Template 1
    > Template 2
    > Template 2
    > Template 4
    >
    > My question is how do I stop the repeat records and just display the
    unique
    > records i.e.
    >
    > Template 1
    > Template 2
    > Template 4
    >
    >

    Nancy Gill Guest

Similar Threads

  1. Duplicate records
    By DuLaus in forum Coldfusion - Advanced Techniques
    Replies: 7
    Last Post: October 25th, 03:20 PM
  2. select all the duplicate records
    By atse in forum ASP
    Replies: 9
    Last Post: October 19th, 06:59 PM
  3. Deleting duplicate records
    By Dinesh.T.K in forum FileMaker
    Replies: 3
    Last Post: August 13th, 12:00 AM
  4. Need help serializing duplicate records
    By Scott in forum FileMaker
    Replies: 2
    Last Post: July 30th, 06:24 PM
  5. Duplicate records?
    By Bridget Eley in forum FileMaker
    Replies: 2
    Last Post: July 28th, 12:06 AM

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