Forum


12:42

15/10/2010

I'm trying to create a simple table using JSON mapping and a java servlet. I'm new to jquery and web programming in general. Please help:
<table id="jsonmap"></table>
<div id="pjmap"></div>
<script type="text/javascript">
jQuery("#jsonmap").jqGrid({ url:'getdata', datatype: "json",
colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
colModel:[ {name:'id',index:'id', width:55},
{name:'invdate',index:'invdate', width:90, jsonmap:"invdate"},
{name:'name',index:'name asc, invdate', width:100},
{name:'amount',index:'amount', width:80, align:"right"},
{name:'tax',index:'tax', width:80, align:"right"},
{name:'total',index:'total', width:80,align:"right"},
{name:'note',index:'note', width:150, sortable:false} ],
rowNum:10, rowList:[10,20,30], pager: '#pjmap', sortname: 'id', viewrecords: true,
sortorder: "desc", jsonReader: { repeatitems : false, id: "0" },
caption: "JSON Mapping", height: '100%' });
jQuery("#jsonmap").jqGrid('navGrid','#pjmap',{edit:false,add:false,del:false});
</script>
My servlet returns so far the following data:
{"jsonmap":[{"id":1, "invdate":"Fri Oct 15 12:31:22 EEST 2010", "name":"name", "amount":"1", "tax":"2"
, "total":"22", "note":"note"}]}
The data is not loading. Please help me.
Thank you,
Alex
17:21

Moderators
30/10/2007

Hello,
Try with this setting of jsonReader
...
jsonReader: { repeatitems : false, id: "0", root:"jsonmap"}
..
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
53 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66