unique dropdown

<i><b>Originally posted by : Joshua Carlisle (jdcar+@pitt.edu)</b></i><br />I was reading Adrian's suggestions to creating a unique combo/dropdown box and he suggests using the dictionary object. Is there a advantage of using this over a simple DISTINCT sql command returning the results in a array and populating the dropdown? It seems like this is a little bit of an overkill and I was wondering the advantages of it. I'm new to ASP but been doing client/server for a long time so I'm trying to change gears a little and I'm wondering if I'm missing something. Thanks. <br />

<i><b>Originally posted by : steve schofield (sschofield@aspfree.com)</b></i><br /><br />adrians demo is just ONE way of doing it. Keep this in mind when doing ASP coding. The more you control on the back end-mainly the database the better. If your sql statements are strong and only bring the data back to the asp page then your dropdown boxes will be unique. Just think of ASP as the glue. Use your db knowledge very wisely! <br /><br />steve<br /><br />------------<br />Joshua Carlisle at 2/24/2000 10:16:48 PM<br /><br />I was reading Adrian's suggestions to creating a unique combo/dropdown box and he suggests using the dictionary object. Is there a advantage of using this over a simple DISTINCT sql command returning the results in a array and populating the dropdown? It seems like this is a little bit of an overkill and I was wondering the advantages of it. I'm new to ASP but been doing client/server for a long time so I'm trying to change gears a little and I'm wondering if I'm missing something. Thanks. <br />