<div>
<div class="content wysiwyg-content">
Here is a snip-it from the sub procedure that displays the drop-down list of colors available:<br />
<br />
&nbsp; &nbsp; if objRS.eof then EXIT SUB<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; response.Write &quot;&lt;select name=&quot;&quot;Color_id&quot;&quot;&gt;&quot;<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; while not objRS.eof<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; response.Write &quot;&lt;option value=&quot;&quot;&quot;&amp;clng(objRS.field<wbr />s(&quot;Color_i<wbr />d&quot;))&amp;&quot;&quot;&quot;&gt;&quot;<wbr />&amp;trim(objR<wbr />S.fields(&quot;<wbr />Color_valu<wbr />e&quot;))&amp;&quot;&lt;/op<wbr />tion&gt;&quot;<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; objRS.movenext<br />
&nbsp; &nbsp; wend<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; response.Write &quot;&lt;/select&gt;&quot;<br />
&nbsp; &nbsp; <br />
<br />
<br />
<br />
I need to display the available inventory from the database for whatever color is selected in this drop-down menu. &nbsp;What would be the best way to do this? &nbsp;Javascript?
</div>
</div>


Here is a snip-it from the sub procedure that displays the drop-down list of colors available:

    if objRS.eof then EXIT SUB
    
    response.Write "<select name=""Color_id"">"
    
    while not objRS.eof
    
    response.Write "<option value="""&clng(objRS.fields("Color_id"))&""">"&trim(objRS.fields("Color_value"))&"</option>"
    
    objRS.movenext
    wend
    
    response.Write "</select>"
    



I need to display the available inventory from the database for whatever color is selected in this drop-down menu.  What would be the best way to do this?  Javascript?

Display info based on drop-down menu selection

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.