Hi to all,

i need to do a dynamic list that keep the data from a filed in a database.
The problem is that i don't want duplicate records...
For example:
In the database field there are more name, but some record have the same name: in the dynamic list name that are repeted will be appare only one time.
Thanks to all!

You could use the distinct function for your sql statement in the recordset.

Go to Advanced in the recordset and enter something like this:

Select DISTINCT Name
from yourtable

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]