none
display records question RRS feed

  • Question

  •  

    Hello! I have a little doubt.

     

    I have an mdb with a table that has some records inside a specific colum.

    So i was trying to display the data using this query and it works:

     

    Code Snippet
     "select Especie from dados_bio3_fauna_UTM_10x10 Order By Especie Asc"

     

     

     

    Then i wrote the results with this code:

     

    Code Snippet
    while (!rs.EOF){
     Response.Write("
    ");
     rs.MoveNext;
    }

     

     

     

    However, i found that i have many repeted values inside the mdb and i would like to write the values but not the repeated ones.

     

    mdb example:

     

    -----------------------------

    |  name  | especie  |  

    -----------------------------

    |  me     |   test      |

    -----------------------------

    | weee   |    other   |

    -----------------------------

    | xptf     |    wwrt    |

    -----------------------------

    | grhpr   |  other     |

    -----------------------------

    | final     |  test      |

    ----------------------------- 

     

    So i would like to write not all the values, but the values that are diferent, in this case only: "test", "other" and "wwrt" 1 time each.

     

    Help is apreciated.

     

    Thanks!!! 

    Thursday, July 26, 2007 7:40 PM

Answers