Re: Navigating JSON sub-arrays dynamically

[Bryce Martin <BMartin@xxxxxxxxxxxx>]

Instead of pulling all the data at once I would suggest a series of Ajax 
calls.  So when someone chooses Ford from the first drop down you issue a 
request to the database for all Ford models.  If they choose another 
manufacturer then go get those and replace the ones that were there with 
the new ones.  This is a very easy and straight forward approach to take 
and execute.


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



Paul Holm <pholm@xxxxxxxxxxxxxxxxx> 
Sent by: web400-bounces@xxxxxxxxxxxx
12/16/2010 03:49 PM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>


To
web400@xxxxxxxxxxxx
cc

Subject
Re: [WEB400] Navigating JSON sub-arrays dynamically






Hi Mike,

Does ASP/.net provide a reusable component to handle this "parent/child" 
drop down list challenge or do you have to code for each occurance? 
This "parent/child" pattern is common in a lot of business apps we run 
into.  (IE  Select a car mfg such as Ford or GM, then based on the 
parent, show the models (F150, Explorer)

Thanks, Paul



Mike Wills wrote:
> I figured it out finally! I found this:
http://inderpreetsingh.com/2010/10/14/javascriptjson-find-index-in-an-array-of-objects/

> <
http://inderpreetsingh.com/2010/10/14/javascriptjson-find-index-in-an-array-of-objects/
> The
> problem with Kevin's solution is that the IDs will not be sequential or 
they
> can change.
>
> > From there these are the two lines that work:
>
>         var i = findIndexByKeyValue(jsonRequestType, "Id", key);
>         $.each(jsonRequestType[i].HourTypeCodes, function(i, item) {
>
> --
> Mike Wills
> http://mikewills.me