Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    7

    Question Unanswered: distinct records dataset display

    Hello Everyone, back again with some more questions for the group!

    I'm developing a database driven application in which I show a group of people. I have a database of people in which some individuals have more than one instance of address or location. On my database this is shown as a duplicate record. (example below)



    Whenever I try to display the record in an ASP dataset within my page I get duplicate instances of the same record (which I know is logical taking into account the way it's laid out on the database). My question is: are there any ways around it? is there a way in which I can display just one name and then two instances of all their biographical info?

    Thank you!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    how do you know it's the same John Smith???????
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2006
    Posts
    7
    umm...well the application deals with fishing captains who sometimes operate from two different locations...that's how I know for a fact and without a doubt that the john smith who has a fishing boat in chicago is the same one who runs a bass fishing operation in orlando.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What happens when another John Smith moves to Orlando and starts fishing?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •