jQuery Grid Plugin - jqGrid - Topic: jqGrid and Oracle Stored Procedure - Unable to display the grid http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid Simple:Press Version 5.7.5.3 tony on jqGrid and Oracle Stored Procedure - Unable to display the grid http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid#p12181 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid#p12181 Hello,

No I mean diffrent - when you send data back to the client before sending it from the server you should do (PHP variant)

header("Content-type: text/xml;charset=utf-8");

echo response;

]]> Thu, 19 Nov 2009 06:25:38 +0200 Jay on jqGrid and Oracle Stored Procedure - Unable to display the grid http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid#p12074 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid#p12074 Changed <meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ /> tag to <meta http-equiv=”Content-Type” content=”text/xml; charset=utf-8″ />. It is just displaying the grid header and not the data.

]]> Tue, 17 Nov 2009 10:49:46 +0200 tony on jqGrid and Oracle Stored Procedure - Unable to display the grid http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid#p12040 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid#p12040 Hello,

Maybe you will need to send the appropriate header before outputting the data to grid - in PHP this is:

header("Content-type: text/xml;charset=utf-8");

]]> Tue, 17 Nov 2009 01:19:52 +0200 Jay on jqGrid and Oracle Stored Procedure - Unable to display the grid http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid#p11927 Help http://www.trirand.com/blog/?page_id=393/help/jqgrid-and-oracle-stored-procedure-unable-to-display-the-grid#p11927 I am trying out the the latest version of jqGrid (3.6) to display the contents of the table using the xml format by calling the Oracle Stored Procedure in the url tag that generates the following output. But, the grid is not being displayed. I am not getting any javascript error (the path to the files are correct).

I have attached the HTML Source and the generated XML from the Oracle Stored Procedure.

Am i missing anything?

Help!!!

===========
HTML Source
===========

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Manage Shipping Methods</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="StyleSheet" type="text/css" href="spm_main.css">
<link rel="stylesheet" type="text/css" media="screen" href="jquery-ui-1.7.2.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="jquery.searchFilter.css" />

<script type="text/javascript" src="jquery.min.js"></script>
<script type="text/javascript" src="jquery-ui-1.7.2.custom.min.js"></script>
<script type="text/javascript" src="jquery.layout.js"></script>
<script type="text/javascript" src="grid.locale-en.js"></script>
<script type="text/javascript" src="jqGrid.min.js"></script>
<script type="text/javascript" src="ui.multiselect.js"></script>

<script type="text/javascript">
jQuery().ready(function ()
{
jQuery("#ShipMethodList").jqGrid({
url:'spm_preq_sm_list_xml',
datatype: "xml",
colNames:['Seq','Description', 'Entered By', 'Entered Date','Updated By','Updated Date'],
colModel:[ {name:'seq',index:'seq', width:50},
{name:'ShipMethod',index:'ShipMethod', width:100},
{name:'EnteredBy',index:'EnteredBy', width:100},
{name:'EnteredDate',index:'EnteredDate', width:80, align:"center"},
{name:'UpdatedBy',index:'UpdatedBy', width:100, align:"right"},
{name:'UpdatedDate',index:'UpdatedDate', width:80,align:"center"} ],
pager: $('#pager'),
rowNum:10,
autowidth: true,
rowList: [10,20],
viewrecords: true,
sortname: 'ShipMethod'
caption: "Shipment Methods"
});
});
$("ShipMethodList").navGrid('#pager',{edit:false,add:false,del:false});
</script>
</head>
<body>
<h4 align="center">Manage Shipping Methods</h4>
<table id="ShipMethodList"></table>
<div id="pager" class="scroll"></div>
</body>
</html>

==============================================
Generated XML from the Oracle Stored Procedure (spm_preq_sm_list_xml)
==============================================
<?xml version='1.0' encoding='utf-8'?>
<rows><page>1</page><total>2</total><records>19</records>
<row id='33444'>
<cell>40</cell>
<cell><![CDATA[AIR]]></cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
<cell><![CDATA[]]></cell>
<cell></cell>
</row>

<row id='33430'>
<cell>10</cell>
<cell><![CDATA[FEDEX]]></cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
</row>

<row id='33443'>
<cell>70</cell>
<cell><![CDATA[RAIL]]></cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
</row>

<row id='33446'>
<cell>60</cell>
<cell><![CDATA[SEA]]></cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
<cell><![CDATA[]]></cell>
<cell></cell>
</row>

<row id='34732'>
<cell>110</cell>
<cell><![CDATA[TEST 1]]></cell>
<cell><![CDATA[3]]></cell>
<cell>13-NOV-09</cell>
<cell><![CDATA[]]></cell>
<cell></cell>
</row>

<row id='34733'>
<cell>120</cell>
<cell><![CDATA[TEST 2]]></cell>
<cell><![CDATA[3]]></cell>
<cell>13-NOV-09</cell>
<cell><![CDATA[]]></cell>
<cell></cell>
</row>

<row id='34734'>
<cell>130</cell>
<cell><![CDATA[TEST 3]]></cell>
<cell><![CDATA[3]]></cell>
<cell>13-NOV-09</cell>
<cell><![CDATA[]]></cell>
<cell></cell>
</row>

<row id='33445'>
<cell>50</cell>
<cell><![CDATA[TRUCK]]></cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
<cell><![CDATA[]]></cell>
<cell></cell>
</row>

<row id='33447'>
<cell>22</cell>
<cell><![CDATA[UPS 2ND DAY AIR]]></cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
<cell><![CDATA[]]></cell>
<cell></cell>
</row>

<row id='33450'>
<cell>30</cell>
<cell><![CDATA[USPS]]></cell>
<cell><![CDATA[3]]></cell>
<cell>18-AUG-09</cell>
<cell><![CDATA[]]></cell>
<cell></cell>
</row>

</rows>
========================

]]> Fri, 13 Nov 2009 16:34:47 +0200