<?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: add a catalog table into colnames</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/add-a-catalog-table-into-colnames</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/add-a-catalog-table-into-colnames/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>tony on add a catalog table into colnames</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/add-a-catalog-table-into-colnames#p13046</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/add-a-catalog-table-into-colnames#p13046</guid>
        	        	<description><![CDATA[<p>Hello,</p>
<p>Maybe you can use setColProp method.</p>
<p>See docs</p>
<p>Best Regards</p>
<p>Tony</p>
]]></description>
        	        	<pubDate>Tue, 15 Dec 2009 19:05:41 +0200</pubDate>
        </item>
        <item>
        	<title>francisco.penaranda on add a catalog table into colnames</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/add-a-catalog-table-into-colnames#p12999</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/add-a-catalog-table-into-colnames#p12999</guid>
        	        	<description><![CDATA[<blockquote>
<p>OK, i can do with php some trick to load this parameters, but is not an ajax action who loads dynamic information.</p>
</blockquote>
<blockquote>
<p>&#60;? echo $somevariable; ?&#62;,</p>
</blockquote>
<blockquote>
<p>and $somevariable= colModel :[name:........., editoptions:{value:"1:Cat1;2:Cat2;....."}]</p>
</blockquote>
<blockquote>
<p>greatings</p>
</blockquote>
<blockquote>
<p>Francisco</p>
</blockquote>
<blockquote>
</blockquote>
<blockquote>
<p>francisco.penaranda said:</p>
<p>I have a catalog table &#8220;Vivientes&#8221; but in when I tried to add a field the editoption is not filling the catalog data, because i dont find some addoption or maybe I&#39;m doing something wrong. To understand better here is part of my code:</p>
<p>&#8230;.</p>
<p>&#160;colModel :[ <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;idusuario&#39;, index:&#39;idusuario&#39;, width:55,editable:false}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;nombres&#39;, index:&#39;nombres&#39;, width:90,editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;fonos&#39;, index:&#39;fonos&#39;, width:80, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;idvivientes&#39;, index:&#39;idvivientes&#39;, width:80, editable:true, edittype:&#39;select&#39;,editoptions:{dataUrl: &#39;ajax/commonactions.php?action=jqgridCombobox&#38;idtable=idviviente&#38;camposhow=nombres&#38;table=Vivientes&#39;}}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;idgarage&#39;, index:&#39;idgarage&#39;, width:80, align:&#39;right&#39;, editable:true},<br />&#160;&#160;&#160;&#160;&#160; {name:&#39;arrendado_a&#39;, index:&#39;arrendado_a&#39;, width:90, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;negocio&#39;, index:&#39;negocio&#39;, width:80, align:&#39;right&#39;, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;depto_no&#39;, index:&#39;depto_no&#39;, width:80, align:&#39;right&#39;, editable:true},<br />&#160;&#160;&#160;&#160;&#160; {name:&#39;piso_no&#39;, index:&#39;piso_no&#39;, width:90, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;mail&#39;, index:&#39;mail&#39;, width:80, align:&#39;right&#39;, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;bloque&#39;, index:&#39;bloque&#39;, width:80, align:&#39;right&#39;, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;no_mascotas&#39;, index:&#39;no_mascotas&#39;, width:150, sortable:false, editable:true} <br />&#160;&#160;&#160; ],</p>
<p>&#8230;.</p>
</p>
<p>and here is my php file</p>
<p>include_once(&#8221;../settings/dbconnection.php&#8221;);<br />$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die(&#8221;Connection Error: &#8221; . mysql_error()); <br />&#160;&#160;&#160; mysql_select_db($database) or die(&#8221;Error conecting to db.&#8221;); <br />extract($_REQUEST);<br />if ($action==&#8221;jqgridCombobox&#8221;){<br />&#160;&#160;&#160; $sql=&#8221;select $idtable, $camposhow from $table order by $idtable&#8221;;<br />&#160;&#160;&#160; $result1 = MYSQL_QUERY($sql);<br />&#160;&#160;&#160; $numberOfRows1 = @MYSQL_NUM_ROWS($result1);<br />&#160;&#160;&#160; for ($j=0;$j&#60;$numberOfRows1;$j++){ <br />&#160;&#160;&#160; &#160;&#160;&#160; $resultado[$j] = MYSQL_RESULT($result1,$j,$camposhow); <br />&#160;&#160;&#160; &#160;&#160;&#160; $idvar[$j] = @MYSQL_RESULT($result1,$j,$idtable); <br />&#160;&#160;&#160; &#160;&#160;&#160; if ($j==$numberOfRows1-1){$retorno.=&#8221;$idvar[$j]:$resultado[$j]&#8220;;}else{$retorno.=&#8221;$idvar[$j]:$resultado[$j];&#8221;;} <br />&#160;&#160;&#160; }; <br />&#160;&#160;&#160; echo $retorno; <br />}</p>
</blockquote>
<hr />
]]></description>
        	        	<pubDate>Mon, 14 Dec 2009 16:17:28 +0200</pubDate>
        </item>
        <item>
        	<title>francisco.penaranda on add a catalog table into colnames</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/add-a-catalog-table-into-colnames#p12982</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/add-a-catalog-table-into-colnames#p12982</guid>
        	        	<description><![CDATA[<p>I have a catalog table "Vivientes" but in when I tried to add a field the editoption is not filling the catalog data, because i dont find some addoption or maybe I&#39;m doing something wrong. To understand better here is part of my code:</p>
<p>....</p>
<p>&#160;colModel :[ <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;idusuario&#39;, index:&#39;idusuario&#39;, width:55,editable:false}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;nombres&#39;, index:&#39;nombres&#39;, width:90,editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;fonos&#39;, index:&#39;fonos&#39;, width:80, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;idvivientes&#39;, index:&#39;idvivientes&#39;, width:80, editable:true, edittype:&#39;select&#39;,editoptions:{dataUrl: &#39;ajax/commonactions.php?action=jqgridCombobox&#38;idtable=idviviente&#38;camposhow=nombres&#38;table=Vivientes&#39;}}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;idgarage&#39;, index:&#39;idgarage&#39;, width:80, align:&#39;right&#39;, editable:true},<br />&#160;&#160;&#160;&#160;&#160; {name:&#39;arrendado_a&#39;, index:&#39;arrendado_a&#39;, width:90, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;negocio&#39;, index:&#39;negocio&#39;, width:80, align:&#39;right&#39;, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;depto_no&#39;, index:&#39;depto_no&#39;, width:80, align:&#39;right&#39;, editable:true},<br />&#160;&#160;&#160;&#160;&#160; {name:&#39;piso_no&#39;, index:&#39;piso_no&#39;, width:90, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;mail&#39;, index:&#39;mail&#39;, width:80, align:&#39;right&#39;, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;bloque&#39;, index:&#39;bloque&#39;, width:80, align:&#39;right&#39;, editable:true}, <br />&#160;&#160;&#160;&#160;&#160; {name:&#39;no_mascotas&#39;, index:&#39;no_mascotas&#39;, width:150, sortable:false, editable:true} <br />&#160;&#160;&#160; ],</p>
<p>....</p>
</p>
<p>and here is my php file</p>
<p>include_once("../settings/dbconnection.php");<br />$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " . mysql_error()); <br />&#160;&#160;&#160; mysql_select_db($database) or die("Error conecting to db."); <br />extract($_REQUEST);<br />if ($action=="jqgridCombobox"){<br />&#160;&#160;&#160; $sql="select $idtable, $camposhow from $table order by $idtable";<br />&#160;&#160;&#160; $result1 = MYSQL_QUERY($sql);<br />&#160;&#160;&#160; $numberOfRows1 = @MYSQL_NUM_ROWS($result1);<br />&#160;&#160;&#160; for ($j=0;$j&#60;$numberOfRows1;$j++){ <br />&#160;&#160;&#160; &#160;&#160;&#160; $resultado[$j] = MYSQL_RESULT($result1,$j,$camposhow); <br />&#160;&#160;&#160; &#160;&#160;&#160; $idvar[$j] = @MYSQL_RESULT($result1,$j,$idtable); <br />&#160;&#160;&#160; &#160;&#160;&#160; if ($j==$numberOfRows1-1){$retorno.="$idvar[$j]:$resultado[$j]";}else{$retorno.="$idvar[$j]:$resultado[$j];";} <br />&#160;&#160;&#160; }; <br />&#160;&#160;&#160; echo $retorno; <br />}</p>
]]></description>
        	        	<pubDate>Mon, 14 Dec 2009 07:08:51 +0200</pubDate>
        </item>
</channel>
</rss>