Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In the previous answer I say you that you should use <code>jsonReader</code> parameter of the jqGrid. The usage of ids having "=" character inside is inside is also very bad. If you have for example in the database <code>"uid=AndrewBryant"</code> as the id, you can place just <code>"AndrewBryant"</code> in the JSON data as the HTML id. I disagree if you say that you have "no choice".</p> <p>In your current example you made <strong>so much errors</strong> on the server side, and use no <code>jsonReader</code> or <code>localReader</code> that it is difficult to comment there. For example you use <code>cells</code> in the data and "CELLS" in the <code>jsonmap</code> column property which you wrote in the wrong way as <code>JSONMAP</code>. In JavaScript the case of characters is very important. Moreover you use <code>"NAME": "Mon Jan 31"</code> instead of 'name' and an identifier as the value. The identifier can not has blanks. You have of course no data with the property "Mon Jan 31" inside of the JSON data.</p> <p>At the end you use the <code>data</code> parameter (<code>data: colD.MOVEMENTS.rows</code>) which mean the usage of <code>localReader</code> instead of <code>jsonReader</code> (see <a href="http://www.trirand.com/jqgridwiki/doku.php?id=wiki%3aretrieving_data#array_data" rel="nofollow">here</a> more information about the <code>localReader</code>).</p> <p>Sorry, but your current code and the data are so dirty and contain so much error, that all looks a garbage and can not work.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload