jQuery Grid Plugin - jqGrid - Topic: Not Getting Data http://www.trirand.com/blog/?page_id=393/help/not-getting-data Simple:Press Version 5.7.5.3 kevinc on Not Getting Data http://www.trirand.com/blog/?page_id=393/help/not-getting-data#p25925 Help http://www.trirand.com/blog/?page_id=393/help/not-getting-data#p25925 Perhaps someone knows what Query String parameters are passed in the URL to the server page? The javascript code is too obfuscated to tell...

This may be my issue. The nature of PL/SQL htp is such that query string variables are required to be defined...so any params passed by any requesting page must be defined in the receiving server page. Is there a jqgrid method I can call to "see" the URL query string as it's being passed?

Barring that I am not sure what the issue could be. Is there any debugging options in jqgrid?

]]> Fri, 10 Feb 2012 22:57:39 +0200 kevinc on Not Getting Data http://www.trirand.com/blog/?page_id=393/help/not-getting-data#p25864 Help http://www.trirand.com/blog/?page_id=393/help/not-getting-data#p25864 I downloaded the install from this site. GitHub appears to have different files, which got me confused.

I have it installed, I hope correctly...the install.txt seemed to be missing a few key points. Like, the JS should load in this order, and there was no mention of jquery-1.7.1.min.js in the install.txt

<script src="js/jquery-1.7.1.min.js" type="text/javascript"></script>

<script src="js/i18n/grid.locale-en.js" type="text/javascript"></script>

<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>

<script src="js/jquery-ui-1.8.17.custom.min.js" type="text/javascript"></script>

and I am not finding "grid.loader.js" at all which the install doc says can be used for debugging(???)

So my page renders the grid, and appears to be styled, but no data. I tried using JSON and XML data source, but still nothing. My XML comes from a PL/SQL procedure running on the web server, and it looks (to me) well formed.

<?xml version="1.0" encoding="utf-8"?>
<rows>
<page>
1
</page>
<total>
2
</total>
<records>
13
</records>
<row id='41'>
<cell>BIO</cell>
<cell>107</cell>
</row>
<row id='42'>
<cell>BIO</cell>
<cell>108</cell>
</row>
<row id='43'>
<cell>BIO</cell>
<cell>113</cell>
</row>
<row id='44'>
<cell>NUR</cell>
<cell>100</cell>
</row>
<row id='45'>
<cell>NUR</cell>
<cell>101</cell>
</row>
<row id='46'>
<cell>NUR</cell>
<cell>102</cell>
</row>
<row id='47'>
<cell>NUR</cell>
<cell>103</cell>
</row>
<row id='48'>
<cell>NUR</cell>
<cell>104</cell>
</row>
<row id='49'>
<cell>NUR</cell>
<cell>200</cell>
</row>
<row id='50'>
<cell>NUR</cell>
<cell>201</cell>
</row>
<row id='51'>
<cell>NUR</cell>
<cell>202</cell>
</row>
<row id='52'>
<cell>HESI</cell>
<cell>MID</cell>
</row>
<row id='53'>
<cell>HESI</cell>
<cell>FIN</cell>
</row>
</rows>

and this is my HTML/js

<script type="text/javascript">
jQuery().ready(function (){
jQuery("#list1").jqGrid({
    url: 'pathtomyurltogetxml',
    datatype: 'xml',
    mtype: 'GET',
    colNames:['SZVNURT_SUBJ_CODE','SZVNURT_CRSE_NUMB'],
    colModel :[
      {name:'SZVNURT_SUBJ_CODE', index:'SZVNURT_SUBJ_CODE', width:100},
      {name:'SZVNURT_CRSE_NUMB', index:'SZVNURT_CRSE_NUMB', width:100}
    ],
    rowNum:10,
    autowidth: true,
    rowList:[10,20,30],
    pager: jQuery('#pager1'),
    sortname: 'SZVNURT_SUBJ_CODE',
    sortorder: 'desc',
    viewrecords: true,
    gridview: true,
    caption: 'XML grid'
  }).navGrid('#pager1',{edit:false,add:false,del:false});
  });
</script>

<BR>
<BR>
<table id="list1"><tr><td/></tr></table>
<div id="pager1"></div>
<BR>
<BR>
<BR>

No data appears on the grid. No errors showing. Pager show Zero pages.

Any help is appreciated.

Thanks,

Kevin

]]> Fri, 03 Feb 2012 17:00:02 +0200