Now I have the following code:
<script language="JavaScript" type="text/javascript">
(function($){
$.fn.selectCombo = function(url, target){
return this.each(function(){
var targetlabel = target.replace(/#/, '');
targetlabel = "[EMAIL PROTECTED]'" + targetlabel + "']";
$(this).change(function() {
$.getJSON(url,{q: $(this).val()}, function(j){
var options = '';
for (var i = 0; i < j.length; i++) {
options += '<option value="' + j[i].oV + '">' + j[i].oT + '</option>';
}
$(target).html(options);
$("option:first", target).attr("selected","selected");
});//end JSON
});//end change fn
});//end return for each
}
})(jQuery);
$(function(){
$('#cat').selectCombo('selectCombo.asp', '#crit');
});
</script>
Is there any way to make the code more efficient? Perhaps getting rid
of having selectCombo as a function since I only plan on using it
once? I'm not sure...
On Oct 30, 10:30 pm, Rob D <[EMAIL PROTECTED]> wrote:
> HiSnooze,
>
> 1. Check out the following tutorials if you haven't already:
>
> http://remysharp.com/2007/01/20/auto-populating-select-boxes-using-jq...
>
> http://remysharp.com/2007/09/18/auto-populate-multiple-select-boxes/
>
> 2. Check out Shelane's plugin:
>
> http://code.google.com/p/jqueryselectcombo/
>
> http://lasso.pro/selectCombo/
>
> 3. Check out my plugin:
>
> http://www.msxhost.com/jquery/linked-selects/json/
>
> Perhaps you can use the example php code in the download to work it out
> for ASP!
>
> Cheers
>
> Rob
>
>
>
> Snoozewrote:
> > 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.)
>
> > __________ NOD32 2627 (20071030) Information __________
>
> > This message was checked by NOD32 antivirus system.
> >http://www.eset.com- Hide quoted text -
>
> - Show quoted text -
