jQuery AJAX & Multiple sp Result Sets

Question

Is it possible to use a stored procedure that returns multiple result sets in json format and process them as part of one request using ajax calls in jquery? In other words, I have a stored procedure that returns several result sets that are to be used with a series of select boxes that are all being filtered by the same criteria.

If any of the select boxes is chosen that value is then passed to the stored procedure and all the subsequent select box updates reflect only results that match the filtered criteria. I don't want to have to call the same sp multiple times to process the results and was trying not to create multiple queries, so I'm wondering if it's possible to store more than one json result in a single request and then store and process them on the client side.

Answer 1

Yes, JSON allows for nested objects and each object could contain one set of results. Without knowing how you are getting from the database to JSON I couldn't tell you exactly how to construct your JSON.

Answer 2

Using the json2.js library ( http://www.json.org/js.html ) you can turn JavaScript object into a string, and vice-versa. So

var obj = {'a':'1'}; //declare some js object
var s = json.stringify(obj); //turn it into a string for data transfer
obj = json.parse(s); //turn it back into a JavaScript object

The example above shows a very simple js object, but this can be substantially more complex, as you can embed arrays and other objects within objects

Answer 3

Alternatively, stop parsing JSON and try using the jQuery taconite plugin. It easily handles multiple changes of all sorts. I absolutely love it.