Return Records and not duplicate them :: Again

[The Ox]

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]

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" <rob@rob.com> wrote in message
news:d19m19$pki$1@forums.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
>
>