Coldfusion Question

[kevinj]

I have a client that has a table called Doctors and a field called Note. Unfortunately the Note field is not set up to deny duplicates so there are duplicate values in that field. Is there a way to set up the query to not grab duplicates but rather, just each possible value only once? My code so far is as follows:

<cfquery name="GetNotes" datasource="finder">
SELECT Note
FROM Doctors
WHERE Note <> ''
ORDER BY Note
</cfquery>

Thanks,

Kevin

[txbakers]

I'm not sure in ColdFusion, but in ANSI SQL you could use the DISTINCT keyword:

select DISTINCT field1,field2 from table

which would return only unique entries.

[Slade]

If the datasource is roughly ANSI compliant (or MS SQL, or MySQL) you can use distinct. The query is evaluated then passed on to the actual database engine.

[kevinj]

Yep, Distinct did the trick. Thanks very much.

Kevin

[lorax]

>> If the datasource is roughly ANSI compliant (or MS SQL, or MySQL) you can use distinct.

That's a useful tidbit I didn't know - thanks Slade.