jQuery Grid Plugin - jqGrid - Topic: navigrid passes wrong ID http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id Simple:Press Version 5.7.5.3 tony on navigrid passes wrong ID http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7926 Help http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7926 Mon, 20 Jul 2009 13:45:07 +0300 wiliampsin on navigrid passes wrong ID http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7925 Help http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7925

I figured this out, it was in my PHP code: 

 

    $responce->rows[$i]['id']=$row[link_id];  <--- i changed this line from ($responce->rows[$i]['link_id']=$row[link_id];)

    $responce->rows[$i]['cell']=array($row[link_id],$row[link_name],$row[link_url]);

    $i++;

}

]]> Mon, 20 Jul 2009 12:45:09 +0300 wiliampsin on navigrid passes wrong ID http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7924 Help http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7924 Here is the json:

{"page":"1","total":2,"records":"11","rows":[{"link_id":"15","cell":["15","test","test"]},{"link_id"

:"11","cell":["11","Tiger Classic","http:\\/\\/www.aidupontwrestling.com\\/"]},{"link_id":"10","cell":["10"

,"Christiansburg Big Blue Tournament","http:\\/\\/www.bluedemonwrestling.com\\/big%20blue.htm"]},{"link_id"

:"9","cell":["9","Christiansburg Big Blue ","http:\\/\\/www.bluedemonwrestling.com\\/big%20blue.htm"]},

{"link_id":"8","cell":["8","Coach Welch in Nat. Finals","http:\\/\\/www.thewrestlingtalk.com\\/wrestling-videos

\\/id-0zTDjCoQcig.html"]},{"link_id":"7","cell":["7","Flo Wrestling","http:\\/\\/www.flowrestling.com\\/"

]},{"link_id":"6","cell":["6","Smyrna Wrestling","http:\\/\\/www.smyrnawrestling.com\\/"]},{"link_id":"5"

,"cell":["5","DE Preps","http:\\/\\/www.depreps.com\\/"]},{"link_id":"4","cell":["4","Beast of East","http

:\\/\\/www.beastwrestling.com\\/"]},{"link_id":"3","cell":["3","Bear Brawlers","http:\\/\\/www.eteamz.com

\\/bearbrawlers\\/"]}]}




Here is what is being sent to the editdb.php?method=delete page: 
oper=del&id=1
In this case the ID should be 15.

]]>
        	        	Mon, 20 Jul 2009 11:51:32 +0300
        
        
        	tony on navigrid passes wrong ID
        	http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7923
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7923
        	        	Hello,


Could you please put a simple response from the server - I mean the json reasponse. You can do this easy when you use FireBug.


Regards


Tony

]]>
        	        	Mon, 20 Jul 2009 11:42:07 +0300
        
        
        	wiliampsin on navigrid passes wrong ID
        	http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7915
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/navigrid-passes-wrong-id#p7915
        	        	I am having problems with my delete function because the navigrid is passing the wrong ID.  It is passing the ID number in regards to the way they are listed out instead of the actual ID of the ID pulled from that database.  Here is the code I'm using:




<script type="text/javascript">
jQuery(document).ready(function(){
jQuery("#list2").jqGrid({
    url:'wrestling_links.php?nd='+new Date().getTime(),
    datatype: 'json',
    colNames:['Link ID','Link Name','Link URL'],
    colModel:[
        {name:'id',index:'link_id', width:55, editable:true, editrule:{readonly:true}},
        {name:'link_name',index:'link_name', width:200, editable:true,editoptions:{size:25},editrules:{required:true}},
        {name:'link_url',index:'link_url', width:425, editable:true,editoptions:{size:25},editrules:{required:true}}
    ],
    pager: jQuery('#pager2'),
    rowNum:10,
    rowList:[10,20,30],
    imgpath: 'themes/basic/images',
    sortname: 'link_id',
    viewrecords: true,
    sortorder: "desc",
    caption: "Links!"
}).navGrid('#pager2',
{add:true, edit:true,view:true, del:true, search:false}, //options
{height:150,width: 400,url:'editdb.php?method=update',reloadAfterSubmit:false,closeAfterEdit:true}, // edit options
{height:150,width: 400,url:'editdb.php?method=add',reloadAfterSubmit:true,closeAfterAdd:true},
{height:100,width: 200,url:'editdb.php?method=delete',reloadAfterSubmit:true,closeAfterAdd:true},
{} // search options
);
});
</script>

]]>
        	        	Mon, 20 Jul 2009 11:15:24 +0300