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
Not Getting Data
03/02/2012
17:00
Avatar
kevinc
Member
Members
Forum Posts: 7
Member Since:
03/02/2012
sp_UserOfflineSmall Offline

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

10/02/2012
22:57
Avatar
kevinc
Member
Members
Forum Posts: 7
Member Since:
03/02/2012
sp_UserOfflineSmall Offline

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?

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
64 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