troubleshooting Question

How do I load a dynamic array from a SQL query into multiple pull down inputs on a classic ASP page?

Avatar of Russell Scheinberg, MCSE Business Intelligence
Russell Scheinberg, MCSE Business IntelligenceFlag for United States of America asked on
Microsoft SQL ServerASPJavaScript
6 Comments1 Solution861 ViewsLast Modified:
Greetings all,

I am trying to figure out the best way to load the same dynamically generated (from a SQL server query) list into multiple pull down (select) input form objects on a classic ASP page. I think it might require a combination of vbscript  (to query the database) and javascript (to hold and display the pull down).  The sql query would look like this:

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.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros