Hi I have a controller sending JSON to my view. I cannot get the data into the TreeGrid. The Json is coming down correctly (I placed it manually and it works). Running this code places the JSON on the webpage. Controller and View below.
Help appreciated. Regards Nate CONTROLLER @service.json def get_report(): import json rows = db(db.neighbourhood.id > 0).select().as_list() concat = '{"response":[' seq =1 for row in rows: row['id'] = seq concat = concat + json.dumps(row)+"," seq = seq+1 innerrows = db(db.report.parent == row.get('id')).select().as_list() for innerrow in innerrows: innerrow['id'] = seq concat = concat + json.dumps(innerrow) + "," seq = seq+1 concat = concat.strip( ',' ) concat = concat + ']},grid;' return concat VIEW {{extend 'layout.html'}} <script type="text/javascript"> jQuery(document).ready(function(){ jQuery.getJSON("{{=URL(r=request,f='call',args=['json','get_report'])}}", function(msg){ jQuery.each(msg, function(){ topicjson = this; $('#treeGrid').jqGrid({ datastr: topicjson, datatype: "json", height: "auto", mType: 'GET', treeGridModel: 'adjacency', colNames: [/*"id",*/"Items","url"], colModel: [ {name: "elementName", width:250, resizable: false}, {name: "url",width:1,hidden:true} ], treeGrid: true, caption: "Neighbourhood", ExpandColumn: "name", ExpandColClick:true, autowidth: true }); }) }); }); </script> <div style="width:180px;"> <table id="treeGrid"> </table> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.