jQuery Grid Plugin - jqGrid

Thanks. That stopped the error.

I still do not have the data displaying in the grid. It is not in the response. All I see is the <table id = 'list' .....> section where as I understand the data should be.

If I clink the sort arrows on the 'ID' column, I get a request to server and response in the Turbogears log and the message "Loading.." flashes, but no visable data.

Does this sound like something missing between the Trubogears controller and the templete / page generation?

Thanks for the help.

this is the log of the dist sent from the controller :

23:06:59,946 DEBUG [sensadata.controllers.root]
{'records': '5', 'total': '1',
'rows': [{'cell': ['10009901', '0', '"11024438"', 'None'], 'id': '279976'},
{'cell': ['10009901', '0', '"11014912"', 'None'], 'id': '279977'},
{'cell': ['10009901', '4423', '"11024421"', 'None'], 'id': '279978'},
{'cell': ['10009901', '4425', '"11014910"', 'None'], 'id': '279979'},
 {'cell': ['12194001', '0', '"11083108"', '0'], 'id': '279975'}],
  'page': '1'}

The sample has ", this has ' . Is that a problem?

Hope this does not sound really dumb.

All of the response viewers are showing the full page without <table id="list" class="scroll"></table>
being replaced with data.

Is the page supposed to load and then send the data request and load the data? I am thinking that Turbogears as I have it know is passing the page and the json data to the stack in TG2 and TG2 expects to do the replacement in the page.

If jqgrid is to do the replacement of  <table id="list" class="scroll"></table> with the data then I need to change my TG2 code.

Thanks for your help. Tell me when I need to send payment for your time.

I must be doing something dumb. This is the exact return sent to the client after the form is displayed with no data.I thought this to be the correct format for the response and the Javascript is to read this and insert into the grid.

Any suggestions?

Does the content-type need to be "json"?

HTTP/1.0 200 OK
Server: PasteWSGIServer/0.5 Python/2.5.4
Date: Mon, 16 Nov 2009 03:18:45 GMT
Pragma: no-cache
Cache-Control: no-cache
Content-Type: text/html; charset=utf-8
Content-Length: 260

{page:"1",total:"1",records:"5", rows:[{"279976","10009901","0","None","None"},{"279977","10009901","0","11014912","None"},{"279978","10009901","4423","11024421","None"},{"279979","10009901","4425","11014910","None"},{"279975","12194001","0","11083108","1"},]}

Is there a way to get the jqgrid.js code with the line feed/ carage returns? now I am getting the error 'invalid object initualizer' and I can not determine where in the code.

If I set the datatype = 'jsonstring' in the html, there is no request sent back to the host.

I am glad someone has been able to get this to work. I have upgraded to grid3.6, gone to the Lightness UI, and switched to the /src .js code.

The response is:

HTTP/1.0 200 OK
Server: PasteWSGIServer/0.5 Python/2.5.4
Date: Mon, 16 Nov 2009 03:18:45 GMT
Pragma: no-cache
Cache-Control: no-cache
Content-Type: text/html; charset=utf-8
Content-Length: 260

{page:”1″,total:”1″,records:”5″, rows:[{"279976","10009901","0","None","None"}{"279977","10009901","0","11014912","None"},{"279978","10009901","4423","11024421","None"},{"279979","10009901","4425","11014910","None"},{"279975","12194001","0","11083108","1"},]}

With NO cr/lf in the data, one long string.

I am getting an error "invalid object initializer"  at line 59 of grid.base.js

parse : function(jsonString) {
        var js = jsonString, msg;
        if (js.substr(0,9) == "while(1);") { js = js.substr(9); }
        if (js.substr(0,2) == "/*") { js = js.substr(2,js.length-4); }
        if(!js) { js = "{}"; }
        ($.jgrid.useJSON===true && typeof (JSON) === 'object' && typeof (JSON.parse) === 'function')
            ? msg = JSON.parse(js)
            : msg = eval('(' + js + ')');                                  <<<<< THIS LINE
        return  msg.hasOwnProperty('d') ? msg.d : msg;
    },
    empty : function () {
        while ( this.firstChild ) this.removeChild( this.firstChild );
    },

Is this indicate the response is not formatted correctly? Incorrect quotes????

In all of this effort, I have identified that the location of files and sub-directories is most important. The CSS section includes and calls files based on the installation instructions. I would check all of the files and locations if you are getting the 404 error.

Thanks for all of the help.