Digital Workshop

Hi, sorry for my english... I will try to explain my problem.

I am developing an application about soccer players. I want to display in a page a list about all the players, but the problem is that in the database the same name appair more than one time (the same player can play in 2 diferents teams the same season)

Anybody knows how to show this list, but without repeat the same name?

Thanks a lot.

This is normally a database design issue as the information that is unique such a player's name should be in a table of its own.

However, assuming your dataset is returning information that could be unique IE just the players name then depending on which DB you are using, you need the SQL command DISTINCT. If you are using Opus Actions instead of scripting this may not be possible but you could alway create a query in the database that returns the information and access this from Opus instead of the table.

Mack

Hi,

As Mack says this is down to the design of your database, which needs to be normalized ;

Each field should contain the smallest meaningful value.
There should be no repeated groups of fields (similar data belongs in the same field).
There should be no unnecessarily repeated data values.
Where practical, all fields in a table should be relevant to every record.

Do a web search - there are plenty of sites which cover this.

The only way I can think of to eliminate duplicates is to store each player's name in an array and check the array before adding another name - but, if you have large amounts of data this will become very slow.