JSON DataTables part x

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Here is the quickest one to load

ASKER

So If I currently have selects of the parameters to choose from (series, age groups, and gender) how do I press that into an ajax format. The gender and age groups are static but the series are dynamically generated.

Thanks so much for this. In the interim I will go back over all that you folks have posted.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Currently I am passing the parameters to results_array.asp using query strings. I get that I need to add those parameters to the ajax call but how do I get them into the asp variables? Currently I do this:

lSeriesID = Request.QueryString("series_id")
iYear = Request.QueryString("year")
sGender = Request.QueryString("gender")
iAgeTo = Request.QueryString("age_to")

Open in new window

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

This is helpful. I believe the years need to be via a link/asp query string because different years have different series. The standings page is not a landing page per se but once there you should be able to toggle between series, age groups, and gender. Changing a year sets everything back to the defaults.

Having said all of that, what I am seeing is that I need to create a form with series, age group, and gender drop-downs. Since the page is not a landing page per se, the series will be initially selected via a query string on the "main" page. The defaults for the others will be "Open" and "Male."

I will start working on this. Please let me know if you see anything wrong with my reasoning. I will re-post as needed.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Getting back on this now. Making progress on my series standings utility. I will repost soon.

ASKER

Better instruction doesn't happen in many schools...

glad you've made some progress! how did you finalize your process (just curious)?

ASKER

No got sidetracked with my server migration. still need to do two things:
1) pass gender, age, and series id to the datatable page in classic asp
2) turn the individual's names into clickable links that will show the individual's race-by-race data.

This wasn't the one that I thought I closed. Oh, well I will create a new post soon. FYI, the page in question is here and it is possible that some of what I need has been posted above by you or padas.

Those clickable links you want can be created on the fly by jquery. That way you don't have to create them in your json which is cumbersome.

I will try and get back to this in about 5hrs.