<?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: Missing Id parameter for delete row</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/missing-id-parameter-for-delete-row</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/missing-id-parameter-for-delete-row/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>nery1f on Missing Id parameter for delete row</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/missing-id-parameter-for-delete-row#p25028</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/missing-id-parameter-for-delete-row#p25028</guid>
        	        	<description><![CDATA[<p>ok,&#160; I fix the problem whit this</p>
</p>
<p>if(($_POST[&#39;oper&#39;]==&#39;del&#39;) &#124;&#124; ($_GET[&#39;oper&#39;]==&#39;del&#39;) )<br />{</p>
<p>&#160;&#160; &#160;$SQL = "delete from bscit_perspectiva where CdgoPrspctva =". .$_POST[&#39;id&#39;];</p>
<p>};</p>
</p>
<p><img class="spSmiley" style="margin:0" title="Laugh" src="/blog/wp-content/forum-smileys/sf-laugh.gif" alt="Laugh" /></p>
]]></description>
        	        	<pubDate>Sun, 30 Oct 2011 20:52:19 +0200</pubDate>
        </item>
        <item>
        	<title>nery1f on Missing Id parameter for delete row</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/missing-id-parameter-for-delete-row#p25027</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/missing-id-parameter-for-delete-row#p25027</guid>
        	        	<description><![CDATA[<p>Hi</p>
<p>I&#160; have a problem pasing the id parameter for delete a row.</p>
<p>I have this code to create the xml</p>
</p>
<p>&#160;&#160;&#160; $s = "&#60;?xml version=&#39;1.0&#39; encoding=&#39;utf-8&#39;?$et\n";<br />&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;rows&#62;";<br />&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;page&#62;".$page."&#60;/page&#62;";<br />&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;total&#62;".$total_pages."&#60;/total&#62;";<br />&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;records&#62;".$count."&#60;/records&#62;";<br />&#160;&#160; &#160;&#160;&#160; &#160;// be sure to put text data in CDATA<br />&#160;&#160; &#160;&#160;&#160; &#160;while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;row id=&#39;". $row[CdgoPrspctva]."&#39;&#62;";&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;cell&#62;". $row[CdgoPrspctva]."&#60;/cell&#62;";<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;cell&#62;". $row[Dscrpcion]."&#60;/cell&#62;";&#160;&#160; &#160;&#160;&#160; &#160;<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;/row&#62;";<br />&#160;&#160; &#160;&#160;&#160; &#160;}<br />&#160;&#160; &#160;&#160;&#160; &#160;$s .= "&#60;/rows&#62;";</p>
</p>
<p>and this for the model</p>
</p>
<p>&#160;&#160;&#160; colNames:[&#39;Inv No&#39;,&#39;Descripcion&#39;],<br />&#160;&#160; &#160;&#160;&#160; &#160;colModel:[<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;CdgoPrspctva&#39;,index:&#39;CdgoPrspctva&#39;, width:55,editable:true,editoptions:{readonly:true,size:10}},<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;Dscrpcion&#39;,index:&#39;Dscrpcion&#39;, width:80,editable:true,editoptions:{size:10} }&#160;&#160; &#160;<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;],</p>
</p>
<p>and this do the add, edit and delete</p>
</p>
<p>$invId = $_POST[&#39;CdgoPrspctva&#39;]; <br />$Dscrpcion = $_POST[&#39;Dscrpcion&#39;]; <br />$clientId = $_POST[&#39;name&#39;]; <br />$amount = $_POST[&#39;amount&#39;]; <br />$tax = $_POST[&#39;tax&#39;]; <br />$total = $_POST[&#39;total&#39;]; <br />$note = $_POST[&#39;note&#39;]; <br />$ship_via== $_POST[&#39;ship_via&#39;];</p>
</p>
<p>if($_POST[&#39;oper&#39;]==&#39;edit&#39;)<br />{<br />&#160;&#160; &#160;$SQL = "update bscit_perspectiva set Dscrpcion=&#39;$Dscrpcion&#39;&#160;&#160; where CdgoPrspctva= $invId"; <br />};</p>
<p>if($_POST[&#39;oper&#39;]==&#39;add&#39;)<br />{<br />&#160;&#160; &#160;$SQL = "insert into bscit_perspectiva values (0,&#39;$Dscrpcion&#39;)"; <br />&#160;&#160; &#160;//echo $SQL.&#39;&#60;br/&#62;&#39;;<br />};</p>
<p>if(($_POST[&#39;oper&#39;]==&#39;del&#39;) &#124;&#124; ($_GET[&#39;oper&#39;]==&#39;del&#39;) )<br />{<br />&#160;&#160; &#160;$SQL = "delete from bscit_perspectiva where CdgoPrspctva =$invId"; <br />};</p>
<p>$result = mysql_query( $SQL );// or die("Ocurrieron errores durante la ejecucion.".mysql_error()); </p>
<p>$deleted_rows = mysql_affected_rows();<br />if ($deleted_rows &#62;= 1) <br />{<br />&#160;&#160; &#160;$status = "success";<br />&#160;&#160; &#160;$message = $deleted_rows." Registro(s) afectado(s)";<br />} else {<br />&#160;&#160; &#160;$status = "fail";<br />&#160;&#160; &#160;$message = "Error al realizar la peticion".&#39;&#60;br/&#62;&#39;.$SQL.&#39;&#60;br/&#62;&#39;.mysql_error();<br />&#160;&#160; &#160;}<br />$s = $status.&#39;;&#39;.$message.&#39;;&#39;.&#39;&#39;;<br />print $s;</p>
</p>
<p>the add and edit work fine but the delete method dont get the id parameter, someone now why?</p>
</p>
<p>thanks for your help and sorry for my english</p></p>
]]></description>
        	        	<pubDate>Sun, 30 Oct 2011 20:01:42 +0200</pubDate>
        </item>
</channel>
</rss>