jQuery AJAX & Multiple sp Result Sets

Posted by Kevin on Stack Overflow See other posts from Stack Overflow or by Kevin
Published on 2009-12-28T19:12:16Z Indexed on 2010/05/09 20:28 UTC
Read the original article Hit count: 236

Filed under:
|
|
|

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.

© Stack Overflow or respective owner

Related posts about jQuery

Related posts about AJAX