Suppressing duplicates

[guineamation]

How can I suppress apparition of duplicate values when writing the contents of a retrieved recordset?

 

[Veep]

From the Transact SQL Reference:

Eliminating Duplicates with DISTINCT-
The DISTINCT keyword eliminates duplicate rows from the results of a SELECT statement. If DISTINCT is not specified, all rows are returned, including duplicates.

 

[bastienk]

old_value = ""

while not rs.oef

  if old_value <> rs("value") then
    response.write rs("value")
    old_value = rs("value")
  end if

wend

Bastien

Cat, the other other white meat