There are several ways of doing it, depending on what you want your
asp program to return.
For example, assuming that your asp program will return the options as
html, depending on the POSTed value of cat that it receives from the
caller...
var Cat = $('select.cat'); // first select
Cat.change(function(){ // onchange event
// get the selected value...
var Opt = Cat.find('option:selected').val();
// clear down the current criteria, request the new options, load
into criteria select...
if(Opt) $('select.crit').empty().load('yourASPprogram.asp',
{cat:Opt});
});
Other alternatives are to return the entire select as html, or to
return the option data as JSON and populate select.crit from a
callback. Or some other alternative.
Of course the above also assumes that select.cat is pre-populated with
the correct options, either from the asp providing the page source, or
from some other ajax call.
On Oct 30, 3:05 pm, Snooze <[EMAIL PROTECTED]> wrote:
> I am trying to make a select box that with populate depending on what
> is selected in the select box before it. Both of these select boxes
> need to draw information from the sql database (I have to use ASP to
> get this information).
>
> I've been looking at some tutorials but am overall very confused as
> how to accomplish this.
>
> I understand that I need to look for a change in the first select box
> to populate the second, but I don't understand how to tell ASP to
> query for different information.
>
> I would like something like this:
>
> <select name="category" class="cat">
> <option value="value from db">label from db</option>
> <option value="value from db">label from db</option>
> <option value="value from db">label from db</option>
> </select>
>
> (I get the list of categories from a database using ASP, there is 37
> of them but this might change.)
>
> <select name="criteria" class="crit">
> <option value="value from db depending on cat chosen">label from db
> depending on cat chosen</option>
> <option value="value from db depending on cat chosen">label from db
> depending on cat chosen</option>
> <option value="value from db depending on cat chosen">label from db
> depending on cat chosen</option>
> </select>
>
> (I need the criteria to be drawn from the database, preferrably using
> ASP, there is also a different number of criteria for each category.)
