Loop over json data structure?

Loop over json data structure?

Hi,

I have the following data structure (shown in code view below) coming back from a query.  How can I loop over this and create an <li></li> for each record on the client side?

The end result should be :

<li><a href="page.htm?id=1">Kate</a></li>

<li><a href="page.htm?id=2">Sarah</a></li>

<li><a href="page.htm?id=3">Tricia</a></li>

The dynamic parts in bold.
    • {
    • "ROWCOUNT":3,
    • "COLUMNS":["ID","NAME"],
    • "DATA":{
    • "id":[1.0,2.0,3.0],
    • "name":["Kate","Sarah","Tricia"]
    • }
    1. }