FranzS on Empty Grid with XML

Fri, 16 Dec 2011 17:19:45 +0200

Hi,

I have a simple xml structure with tax info by County. All attempts to display that data in a Grid with type xml fails with an empty grid.

I use Firebug to inspect the script. The return is a valid 200 OK response with the xml data.

Thanks for any help

This is my HTML file:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">

<HTML>

<HEAD>

<TITLE>Main Menu</TITLE>

<link type="text/css" href="http://192.168.1.4/test/admin/jq/css/humanity/jquery-ui-1.7.1.custom.css" rel="stylesheet" />

<link rel="stylesheet" type="text/css" media="screen" href="/blog/view-source:http:/192.168.1.4/feeling-live/admin/jq/css/ui.jqgrid.css" />

<link rel="stylesheet" type="text/css" media="screen" href="/blog/view-source:http:/192.168.1.4/feeling-live/admin/jq/themes/jqModal.css" />

<script type="text/javascript" src="/blog/view-source:http:/192.168.1.4/feeling-live/admin/jq/js/jquery-1.7.1.min.js"></script>

<script type="text/javascript" src="/blog/view-source:http:/192.168.1.4/feeling-live/admin/jq/js/jquery-ui-1.7.1.custom.min.js"></script>

<script type="text/javascript" src="http://192.168.1.4/test/admin/jq/js/i18n/grid.locale-en.js" ></script>
<script type="text/javascript" src="http://192.168.1.4/test/admin/jq/js/jquery.jqGrid.min.js"></script>
<script type="text/javascript" src="http://192.168.1.4/test/admin/jq/js/jqModal.js"></script>
<script type="text/javascript" src="http://192.168.1.4/test/admin/jq/js/jqDnR.js"></script>

<script type="text/javascript" src="http://192.168.1.4/test/admin/jq/js/jquery.dimensions.js"></script>

<script type="text/javascript">

$(document).ready(function() {

jQuery("#ctylist").jqGrid({ url:'tax.cfc?method=getrates&dsn=test', datatype: 'xml', mtype: 'GET', colNames:['ID','State ID','County','Rate'], colModel :[

				{name:'id',index:'id', width:50,resizable:false, sorttype:"int",hidden:true},

				{name:'stateid',index:'stateid', width:50,resizable:false, sorttype:"int",hidden:true},

				{name:'CountyName',index:'CountyName', width:150,resizable:false, sorttype:"text"},

				{name:'CountyTax',index:'CountyTax', width:100, sorttype:"float"}

		],
		rowNum:20,

		rowList:[10,20,30], 
		pager: '#ctylistpager',

		sortname: 'id', 
		viewrecords: true, 
		sortorder: "desc",

		caption:"Counties",
		height:'auto',
		recordtext:'',

		pgtext:'',
		toolbar:[true,"top"]	
	}).navGrid('#ctylistpager',{edit:true,add:true,search:false}); 
});//End document.ready function

</script>

</head>

<body>

<table id="ctylist" class="scroll" cellpadding="0" cellspacing="0"></table>

<div id="ctylistpager" class="scroll" style="display:block"></div>

</body>

</html>


My xml response is:

<?xml version='1.0' encoding='UTF-8'?>
<rows><records>17</records>
<row id='1'><cell>80</cell><![CDATA[Carson City]]></cell><cell>7.475</cell></row>
<row id='2'><cell>80</cell><![CDATA[Churchill]]></cell><cell>7.600</cell></row>
<row id='3'><cell>80</cell><![CDATA[Clark]]></cell><cell>8.100</cell></row>
<row id='4'><cell>80</cell><![CDATA[Douglas]]></cell><cell>7.100</cell></row>

<row id='5'><cell>80</cell><![CDATA[Elko]]></cell><cell>6.850</cell></row>
<row id='6'><cell>80</cell><![CDATA[Esmeralda]]></cell><cell>6.850</cell></row>
<row id='7'><cell>80</cell><![CDATA[Eureka]]></cell><cell>6.850</cell></row>
<row id='8'><cell>80</cell><![CDATA[Humboldt]]></cell><cell>6.850</cell></row>
<row id='9'><cell>80</cell><![CDATA[Lander]]></cell><cell>7.100</cell></row>
<row id='10'><cell>80</cell><![CDATA[Lincoln]]></cell><cell>7.100</cell></row>

<row id='11'><cell>80</cell><![CDATA[Lyon]]></cell><cell>7.100</cell></row>
<row id='12'><cell>80</cell><![CDATA[Mineral]]></cell><cell>6.850</cell></row>
<row id='13'><cell>80</cell><![CDATA[Nye]]></cell><cell>7.100</cell></row>
<row id='14'><cell>80</cell><![CDATA[Pershing]]></cell><cell>7.100</cell></row>
<row id='15'><cell>80</cell><![CDATA[Storey]]></cell><cell>7.600</cell></row>
<row id='16'><cell>80</cell><![CDATA[Washoe]]></cell><cell>7.725</cell></row>

<row id='17'><cell>80</cell><![CDATA[White Pine]]></cell><cell>7.475</cell></row>

</rows>

jQuery Grid Plugin - jqGrid - Topic: Empty Grid with XML

FranzS on Empty Grid with XML