Forum


13:00

06/02/2009

Please provide suggestions for resolving a situation where my grid contains no data despite it being properly returned by the server. Grid definition and returned data follow. No errors encountered:
Thanks
jQuery(document).ready(function(){
jQuery("#ccharges").jqGrid({
url:'/servlet/tCaseEdit?what=getcriminalcharges&casenum=<jsp:getProperty name="background" property="casenum"/>',
datatype: 'xml',
mtype: 'GET',
colNames:['Charge','Type','Pending','Disposition','Type','Reportable',
'','','','','','','','',''],
colModel :[
{name:'charge', index:'charge', editable: true,
editrules:{edithidden:true,required:true}, edittype:'select',
hidden:false, width:100, align:'left'},
{name:'ctype', index:'ctype', editable: true,
editrules:{edithidden:true}, edittype: 'select',
hidden:false, width:100, align:'left'},
{name:'pending', index:'pending', editable: true,
editrules:{edithidden:true}, edittype: 'checkbox',
hidden:false,width:100, align:'center'},
{name:'disposition', index:'disposition', editable: true,
editrules:{edithidden:true}, edittype:'select',
hidden:false,width:100, align:'left'},
{name:'dtype', index:'dtype', editable: true,
editrules:{edithidden:true},edittype:'select',
hidden:false,width:100, align:'left'},
{name:'reportable', index:'reportable', editable: true,
editrules:{edithidden:true}, edittype: 'checkbox',
hidden:false,width:100,align:'center'},
{name:'chid', index:'chid', editable: false,
editrules:{edithidden:false}, editytype:'text',hidden:true},
{name:'reportable200s', index:'reportable200s', editable: true,
editrules:{edithidden:true}, edittype: 'checkbox',hidden:true},
{name:'chdisclosure', index:'chdisclosure', editable: true,
editrules:{edithidden:true},edittype:'checkbox',hidden:true},
{name:'chprisrc', index:'chpriscr', editable: true,
editrules:{edithidden:true},edittype:'select',hidden:true},
{name:'chsecsrc', index:'chsecscr', editable: true,
editrules:{edithidden:true},edittype:'select',hidden:true},
{name:'dpdisclosure', index:'dpdisclosure', editable: true,
editrules:{edithidden:true},edittype:'checkbox',hidden:true},
{name:'dpprisrc', index:'dppriscr', editable: true,
editrules:{edithidden:true},edittype:'select',hidden:true},
{name:'dpsecsrc', index:'dpsecscr', editable: true,
editrules:{edithidden:true},edittype:'select',hidden:true},
{name:'dpgt5yr', index:'dpgt5yr', editable: true,
editrules:{edithidden:true},edittype:'checkbox',hidden:true}],
pager: jQuery('#ccpager'),
rowNum: 10,
rowList:[10,20,30],
sortname: 'chid',
sortorder: "desc",
viewrecords: true,
imgpath: '/dsa/jqGrid/themes/basic/images',
caption: 'Criminal Charges',
xmlReader: {
root:"charges",
row:"charge",
total:"chargeset>totalpages",
records:"chargeset>totalcharges",
repeatitems:false,
id:"chid"
}
});
});
Data sucessfully returned:
<chargeset>
<request>true</request>
<charges>
<charge>
<chid>23</chid>
<charge>1</charge>
<ctype></ctype>
<pending></pending>
<reportable200s></reportable200s>
<chdisclosure></chdisclosure>
<chprisrc></chprisrc>
<chsecsrc></chsecsrc>
<disposition></disposition>
<dtype></dtype>
<reportable></reportable>
<dpdisclosure></dpdisclosure>
<dpprisrc></dpprisrc>
<dpsecsrc></dpsecsrc>
<dpgt5yr></dpgt5yr>
</charge>
</charges>
<totalpages>1</totalpages>
<totalcharges>1</totalcharges>
</chargeset>
11:09

Moderators
30/10/2007

Hello,
All seems to be OK. Really do not see something wrong. Could you please give me link to the problem?
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.
02:46

Moderators
30/10/2007

Hello,
Could you please send me the grid configuration and generated xml file. Will try to simulate this.
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.
10:34

06/02/2009

Hi Tony, I changed the grid definition slightly from what is posted above, but the grid is still not being loaded with data. Rather than use xmlreader as the datatype, it is now using xmlstring because the xml comes over as part of the response rather than in a file.
The grid definition is followed by the text of the response below. I've verified that ccXml is being properly set with the xml in the response.
Thanks for any help you can provide.
var ccLoader = xmlLoader('/servlet/tCaseEdit?what=getcriminalcharges&casenum=<jsp:getProperty name="background" property="casenum"/>');
var ccXml = "not set yet";
var rootElem = ccLoader.documentElement;
if(!rootElem.xml)
ccXml = (new XMLSerializer()).serializeToString(rootElem);
else
ccXml = rootElem.xml;
//alert(ccXml);
// the grid to display criminal charge data
jQuery(document).ready(function(){
jQuery("#ccharges").jqGrid({
datatype: 'xmlstring',
datastr: ccXml,
colNames:['Charge','Type','Pending','Disposition','Type','Reportable',
'','','','','','','','',''],
colModel :[
{name:'charge', index:'charge', editable: true,
editrules:{edithidden:true,required:true}, edittype:'select',
hidden:false, width:100, align:'left',
editoptions: { value: "1:Theft; 2:'Motor Vehicle'; 3:'Disorderly Conduct'" }},
{name:'ctype', index:'ctype', editable: true,
editrules:{edithidden:true}, edittype: 'select',
hidden:false, width:100, align:'left'},
{name:'pending', index:'pending', editable: true,
editrules:{edithidden:true}, edittype: 'checkbox',
hidden:false,width:100, align:'center'},
{name:'disposition', index:'disposition', editable: true,
editrules:{edithidden:true}, edittype:'select',
hidden:false,width:100, align:'left'},
{name:'dtype', index:'dtype', editable: true,
editrules:{edithidden:true},edittype:'select',
hidden:false,width:100, align:'left'},
{name:'reportable', index:'reportable', editable: true,
editrules:{edithidden:true}, edittype: 'checkbox',
hidden:false,width:100,align:'center'},
{name:'chid', index:'chid', editable: false,
editrules:{edithidden:false}, editytype:'text',hidden:true},
{name:'reportable200s', index:'reportable200s', editable: true,
editrules:{edithidden:true}, edittype: 'checkbox',hidden:true},
{name:'chdisclosure', index:'chdisclosure', editable: true,
editrules:{edithidden:true},edittype:'checkbox',hidden:true},
{name:'chprisrc', index:'chpriscr', editable: true,
editrules:{edithidden:true},edittype:'select',hidden:true},
{name:'chsecsrc', index:'chsecscr', editable: true,
editrules:{edithidden:true},edittype:'select',hidden:true},
{name:'dpdisclosure', index:'dpdisclosure', editable: true,
editrules:{edithidden:true},edittype:'checkbox',hidden:true},
{name:'dpprisrc', index:'dppriscr', editable: true,
editrules:{edithidden:true},edittype:'select',hidden:true},
{name:'dpsecsrc', index:'dpsecscr', editable: true,
editrules:{edithidden:true},edittype:'select',hidden:true},
{name:'dpgt5yr', index:'dpgt5yr', editable: true,
editrules:{edithidden:true},edittype:'checkbox',hidden:true}],
pager: jQuery('#ccpager'),
rowNum: 10,
rowList:[10,20,30],
sortname: 'chid',
sortorder: "desc",
viewrecords: true,
imgpath: '/dsa/jqGrid/themes/basic/images',
caption: 'Criminal Charges'
});
});
HTTP/1.1 200 OK
Server: Netscape-Enterprise/6.0
Date: Wed, 04 Mar 2009 16:17:21 GMT
Pragma: no-cache
Cache-control: no-cache
Expires: Wed Mar 04 11:17:21 EST 2009
Content-type: text/xml
Content-length: 559
<?xml version='1.0' encoding='utf-8'?>
<chargeset>
<charges>
<charge>
<chid>23</chid>
<charge>1</charge>
<ctype></ctype>
<pending></pending>
<reportable200s></reportable200s>
<chdisclosure></chdisclosure>
<chprisrc></chprisrc>
<chsecsrc></chsecsrc>
<disposition></disposition>
<dtype></dtype>
<reportable></reportable>
<dpdisclosure></dpdisclosure>
<dpprisrc></dpprisrc>
<dpsecsrc></dpsecsrc>
<dpgt5yr></dpgt5yr>
</charge>
</charges>
<totalpages>1</totalpages>
<totalcharges>1</totalcharges>
</chargeset>
01:06

Moderators
30/10/2007

Hello
Try to set the data string direct - I mean
ccXml = "<?xml.......";
and test.
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:
50 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