If there a simple way to populate a drop down list from a database and ignore duplicate items?
for example a contact address book will probably contain more than one person living in the same town. You wouldn't really want to put all occurances of the town in the dropdown list.
If there a simple way to populate a drop down list from a database and ignore duplicate items?
for example a contact address book will probably contain more than one person living in the same town. You wouldn't really want to put all occurances of the town in the dropdown list.
Any idea?
thanks
Paul - Complete Muppet, Borderline Feeble!
There is an easier way. In your database make seperate fields. Refering back to your example, you could make the following fields.
Name Address Town City Country
Then just search through them and populate your list e.g
WHAT_TOWN = Request.Form("TOWN")
SQL = "Select * From TABLENAME where Town like '%" & WHAT_TOWN & "%' ORDER BY Name"
Topic Locked
Posted - 23 July 2001 : 09:48:24
