Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Empty Grid with XML
16/12/2011
17:19
Avatar
FranzS
New Member
Members
Forum Posts: 2
Member Since:
16/12/2011
sp_UserOfflineSmall Offline

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>
Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information