Solved

Display info based on drop-down menu selection

Posted on 2013-06-14
1
422 Views
Last Modified: 2013-06-17
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?
0
Comment
Question by:AdrienneSperber
1 Comment
 
LVL 32

Accepted Solution

by:
Big Monty earned 500 total points
Comment Utility
if you don't want to refresh the page once a selection is made, you'll need to use ajax:

http://api.jquery.com/jQuery.ajax/
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now