<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Unable to load JSON data into jqGrid from server</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/unable-to-load-json-data-into-jqgrid-from-server</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/unable-to-load-json-data-into-jqgrid-from-server/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>ultimatum on Unable to load JSON data into jqGrid from server</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/unable-to-load-json-data-into-jqgrid-from-server#p27214</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/unable-to-load-json-data-into-jqgrid-from-server#p27214</guid>
        	        	<description><![CDATA[<p>Hey guys,</p>
<p>I&#39;m trying to fix someone else&#39;s code and I&#39;m having difficulties getting the data into the grid. The grid loads perfectly without errors but the data never shows up.</p>
</p>
<p>First here&#39;s the json reponse from the server when I manually make the request just to check if it works:</p>
</p>
<p>{"status":"success","numRecords":"1","startRecord":1,"endRecord":"1","currentPage":1,"numPages":1,"headers":["Id","FamilyId","RegistrationKey","FirstName","MiddleName","LastName","HomeStreet","HomeCity","HomeState","HomePostalCode","HomeCountryRegion"],"feedback":[["13146","13146","11a48423a5b9c80c370940321eff2bbb","Dmitry","","Chayka","11 Testing","Toronto","CO","M1T 3P1","Canada"]]}</p>
</p>
<p>And this is the code which should implement the response from the server and populate the grid:</p>
</p>
<p class="p1">$("#jqgResultsList").jqGrid({</p>
<p class="p1">&#160; &#160; url: &#39;<a href="http://www.lacoptsdb.org/php/getsearchresults.php?&#038;#39" rel="nofollow" target="_blank">http://www.lacoptsdb.org/php/getsearchresults.php?&#038;#39</a>; + &#60;?php echo $urlparams; ?&#62; + &#39;&#39;,</p>
<p class="p2">&#160; &#160; datatype: &#39;json&#39;,</p>
<p class="p2">autowidth: true,</p>
<p class="p2">colNames: eval("([" + colnames + "])"),</p>
<p class="p2">colModel: eval("([" + colmodel + "])"),</p>
<p class="p1">&#160; &#160; pager: &#39;#jqgResultsPager&#39;,</p>
<p class="p2">&#160; &#160; rowNum: 200,</p>
<p class="p2">&#160; &#160; rowList: [200,400,600,1000],</p>
<p class="p2">&#160; &#160; viewrecords: true,</p>
<p class="p2">height: &#39;auto&#39;,</p>
<p class="p2">multiselect: true,</p>
<p class="p2">&#160; &#160; caption: &#39;Search Results&#39;,</p>
<p class="p4">&#160;</p>
<p class="p3">afterInsertRow : function(rowid, rowdata, rowelem) {</p>
<p class="p3">// Only show expander for those with family members</p>
<p class="p3">if(rowdata.HiddenFamilyCount == 0) {</p>
<p class="p3">$("#"+rowid+" td:eq(1)").empty().unbind("click");</p>
<p class="p3">} &#160;</p>
<p class="p3">},</p>
<p class="p4">&#160;</p>
<p class="p2">gridComplete: function(){</p>
<p class="p2">var ids = $("#jqgResultsList").getDataIDs();</p>
<p class="p2">var rowData = $("#jqgResultsList").getRowData();</p>
<p class="p2">for(var i=0;i&#60;ids.length;i++){</p>
<p class="p1">var col = $(&#39;#jqgResultsList&#39;).getCol(&#39;HiddenRegKey&#39;, false);</p>
<p class="p2">var regKey = col[i];</p>
<p class="p2">var cl = ids[i];</p>
<p class="p1">be = "&#60;input style=&#39;margin-right:2px;&#39; type=&#39;image&#39; src=&#39;/images/icon-edit.png&#39; title=&#39;Edit&#39; value=&#39;Edit&#39; onclick="editRow("+cl+",&#39;"+regKey+"&#39;);"&#160; /&#62;";&#160;</p>
<p class="p1">bd = "&#60;input type=&#39;image&#39; src=&#39;/images/icon-trash.jpg&#39; title=&#39;Delete&#39; value=&#39;Delete&#39; onclick="deleteRow("+cl+",&#39;"+regKey+"&#39;);"&#160; /&#62;";&#160;</p>
<p class="p2">$("#jqgResultsList").setRowData(ids[i],{Actions:be+bd});</p>
<p class="p2">}</p>
<p class="p4">&#160;</p>
<p class="p3">// Show the additional grid options when it is done loading</p>
<p class="p3">// Display Options &#124; Export to Excel, etc...</p>
<p class="p2">$(&#39;#quickLinks&#39;).show();</p>
<p class="p2">}</p>
<p class="p4">&#160;</p>
<p class="p2">})</p>
<p class="p3">.navGrid(&#39;#jqgResultsPager&#39;,{edit:false,add:false,del:false})	// Change to del:true when mass-delete is ready</p>
<p class="p1">.jqGrid(&#39;filterToolbar&#39;,{</p>
<p class="p2">stringResult: true,</p>
<p class="p2">searchOnEnter : false</p>
<p class="p2">})</p>
<p class="p2">;</p>
<p class="p2">}</p>
<p class="p2">&#160;</p>
<p class="p2">I don&#39;t understand where the response is being held after the request in the "url:" attribute happens. How do I check if it passed or failed? Please help.</p>
<p class="p2">&#160;</p>
<p class="p2">Thank you all in advance,</p>
<p class="p2">&#160;</p>
<p class="p2">- ultimatum</p>
]]></description>
        	        	<pubDate>Tue, 28 Aug 2012 05:21:21 +0300</pubDate>
        </item>
</channel>
</rss>