Forum


17:19

16/12/2011

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>
Most Users Ever Online: 715
Currently Online:
56 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