How do I load a dynamic array from a SQL query into multiple pull down inputs on a classic ASP page?
SELECT ListID, Symbol FROM Deals WHERE Active = 1
This would give me an array of unkown rows with ListID and Symbol pairs.
I then have a form with multiple (20) rows and each row needs to have the values of this array loaded into a pull down for one of the entries.
<select name="selDeal" id="selDeal">
<option value="ListID value from array">Symbol value from array</option>
I began to work on this but realized there might be a simple way to do it and I might not have to re-invent the wheel to do it if someone has already dealt with this scenario.