jQuery Grid Plugin - jqGrid - Topic: No data appears in grid http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid Simple:Press Version 5.7.5.3 tony on No data appears in grid http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5598 Help http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5598 Hello,

Something is wrong with your request. I recommend first - get the generated xml and use it as datatype: 'xmlstring'  in the grid. Refer in the docs and examples

Regards

Tony

]]> Wed, 25 Mar 2009 11:10:20 +0200 donnek on No data appears in grid http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5558 Help http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5558 I've downloaded the non-minified jquery-1.3.2 from their site, and renamed it to jquery.js.  Running the page, Firebug says there is a problem at line 3633:

// Send the data
3632 try {
3633 xhr.send(s.data);
3634 } catch(e) {
3635 jQuery.handleError(s, xhr, null, e);
3636 }

This doesn't mean much to me, I'm afraid Cry

]]> Tue, 24 Mar 2009 04:01:35 +0200 donnek on No data appears in grid http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5556 Help http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5556 I had just added this query to index.html in order to be sure that some data was being returned from the db - I've taken it out now.  What I don't understand is that data is definitely coming back from the db (as this query showed) and Firebug seems to be showing a properly formatted response, but no data is appearing in the grid.

]]> Tue, 24 Mar 2009 03:50:50 +0200 tony on No data appears in grid http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5554 Help http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5554 Hello,

Remove or comment this line:

echo “Number of records: “.$count;

and see what is happen.

Regards

Tony

]]> Tue, 24 Mar 2009 03:17:00 +0200 donnek on No data appears in grid http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5535 Help http://www.trirand.com/blog/?page_id=393/help/no-data-appears-in-grid#p5535 I'm going through the "Creating your first grid" tutorial, and have set up the data, the index.html and example.php as suggested.  However, when I run the page, I get the grid layout, but no data inside it.  I have added al query to index.php as well:

$db = mysql_connect('localhost', 'myuser', 'mypassword') or die("Connection Error: " . mysql_error());
$myinv=mysql_select_db('mydatabase', $db) or die("Error connecting to db.");
$result = mysql_query("SELECT COUNT(*) AS count FROM invheader");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];
echo "Number of records: ".$count;

and this shows, below the empty grid:

Number of records: 2

as expected (there are two records in the db table), which suggests access to the db is OK.

The Firebug console gives the Response as:

<?xml version='1.0' encoding='utf-8'?><rows><page>1</page><total>1</total><records>2</records><row id
='2'><cell>2</cell><cell>2009-03-24</cell><cell>24.00</cell><cell>3.00</cell><cell>27.00</cell><cell
><![CDATA[watch re payment]]></cell></row><row id='1'><cell>1</cell><cell>2009-03-23</cell><cell>5.00
</cell><cell>1.00</cell><cell>6.00</cell><cell><![CDATA[first entry]]></cell></row></rows>

which seems to suggest that XML is making it back to the page, but is just not being displayed for some reason.

Any suggestions on what might be wrong?

I'm using Firefox 3.0.1 on openSUSE 10.2.

Thanks

Kevin

]]> Mon, 23 Mar 2009 14:59:46 +0200