Where would one get this jqGrid Tree, and can you post a sample JSON
dataset that this is supposed to work with?
On Monday, March 25, 2013 3:51:10 PM UTC-7, Nate wrote:
>
> Nothing in the console. Firebug reports
>
> No Javascript on this pageIf <script> tags have a "type" attribute, it
> should equal "text/javascript" or "application/javascript". Also scripts
> must be parsable (syntactically correct).
>
>
> On Monday, March 25, 2013 11:15:31 PM UTC+11, Willoughby wrote:
>>
>> Do you get any errors in the console? That's the first place I usually
>> look...
>>
>> On Sunday, March 24, 2013 8:42:45 PM UTC-4, Nate wrote:
>>>
>>> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
