sql « json « jQuery Q&A

1. need to populate a dropdown list from sql server sql using jquery/json    stackoverflow.com

Can anybody provide me with an example of how to populate a dropdown list from data in a sql server database. I have just an html page with no server-side anything... ...

2. Javascript libraries that allow for SQL-like queries on JSON data?    stackoverflow.com

Say our JSON data comes from a single MySQL table:

someJSON =    [ { name: 'bill' , sex:'M', income:50000 },
          ...

3. How can I query Json from the client side, kind of like a query or SQL-type language?    stackoverflow.com

What's the best way to query JSON from the client side? i.e. I have 100 json items, i query and it returns the 4 json items that match? Maybe a plugin or ...

4. SQL style JOIN on JSON data    stackoverflow.com

Is there any way efficiently to join JSON data? Suppose we have two JSON datasets:

{"COLORS":[[1,red],[2,yellow],[3,orange]]}

{"FRUITS":[[1,apple],[2,banana],[3,orange]]}

{"NEW_FRUITS":[[1,apple,red],[2,banana,yellow],[3,orange,orange]]}