<?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: Include combobox in the inline editing</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/include-combobox-in-the-inline-editing</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/include-combobox-in-the-inline-editing/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>trufo_1 on Include combobox in the inline editing</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/include-combobox-in-the-inline-editing#p26531</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/include-combobox-in-the-inline-editing#p26531</guid>
        	        	<description><![CDATA[<p>Hi,</p>
</p>
<p>I would like to include a combo box in the inline editing. I am using the following code but when I select a value and I finish the edition, it changes again to the previous value. What am I doing wrong?</p>
</p>
<p>Thank you very much in advance.</p>
</p>
<p>This is the concrete line:</p>
<p><em>$grid-&#62;setSelect("CustomerID", "SELECT DISTINCT CustomerID,  CustomerID FROM orders", true, true, false, array(""=&#62;"Todas"));</em></p>
</p>
<p>This the complete code:</p>
<p>&#60;?php<br />ini_set("display_errors","1");<br />require_once &#39;jq-config.php&#39;;<br />require_once "php/jqAutocomplete.php";<br />require_once "php/jqCalendar.php";<br />require_once "php/jqGrid.php";<br />require_once "php/jqGridPdo.php";<br />$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);<br />$conn-&#62;query("SET NAMES utf8");</p>
<p>$grid = new jqGridRender($conn);<br />$grid-&#62;SelectCommand = &#39;SELECT OrderID, OrderDate, CustomerID, Freight, ShipName FROM orders&#39;;<br />$grid-&#62;dataType = &#39;json&#39;;<br />$grid-&#62;table ="orders";<br />$grid-&#62;setPrimaryKeyId("OrderID");<br />$grid-&#62;setColModel();<br />$grid-&#62;setUrl(&#39;myfirstgrid.php&#39;);<br />$grid-&#62;cacheCount = true;<br />$grid-&#62;setGridOptions(array(<br />&#160;&#160;&#160; "caption"=&#62;"This is custom Caption",<br />&#160;&#160;&#160; "rowNum"=&#62;10,<br />&#160;&#160;&#160; "sortname"=&#62;"OrderID",<br />&#160;&#160;&#160; "hoverrows"=&#62;true,<br />&#160;&#160;&#160; "rowList"=&#62;array(10,20,50),<br />&#160;&#160;&#160; "postData"=&#62;array("grid_recs"=&#62;776)<br />&#160;&#160;&#160; ));<br />$grid-&#62;setColProperty("OrderID", array("label"=&#62;"ID", "width"=&#62;60, "editable"=&#62;false));<br />$grid-&#62;setColProperty("OrderDate", array(<br />&#160;&#160;&#160; "formatter"=&#62;"date",<br />&#160;&#160;&#160; "formatoptions"=&#62;array("srcformat"=&#62;"Y-m-d H:i:s","newformat"=&#62;"m/d/Y"), "editable"=&#62;false<br />&#160;&#160;&#160; )<br />);<br />$grid-&#62;setColProperty("ShipName",array("editable"=&#62;false));<br />$grid-&#62;setDatepicker("OrderDate",array("buttonOnly"=&#62;false));<br />$grid-&#62;setSelect("CustomerID", "SELECT DISTINCT CustomerID, CustomerID FROM orders", true, true, false, array(""=&#62;"Todas"));<br />$grid-&#62;datearray = array(&#39;OrderDate&#39;);<br />$grouping = &#60;&#60;&#60; GROUP<br />jQuery("#grid").jqGrid(&#39;setGroupHeaders&#39;,{<br />&#160;&#160;&#160; "useColSpanStyle":false,<br />&#160;&#160;&#160; "groupHeaders" : [<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; { "startColumnName":&#39;OrderID&#39;, "numberOfColumns":2, "titleText":&#39;Order Info&#39; },<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; { "startColumnName":&#39;CustomerID&#39;, "numberOfColumns":3, "titleText":&#39;Shipping Details&#39; }<br />&#160;&#160;&#160; ]<br />});<br />GROUP;<br />$grid-&#62;setJSCode($grouping);<br />$grid-&#62;navigator = false;<br />$onselrow = &#60;&#60;&#60; ONSELROW<br />function(rowid, selected)<br />{<br />&#160;&#160;&#160; if(rowid &#38;&#38; rowid !== lastSelection) {<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; $("#grid").jqGrid(&#39;restoreRow&#39;, lastSelection);<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; $("#grid").jqGrid(&#39;editRow&#39;, rowid, true);<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; lastSelection = rowid;<br />&#160;&#160;&#160; }<br />}<br />ONSELROW;<br />$grid-&#62;setGridEvent(&#39;onSelectRow&#39;, $onselrow);<br />$grid-&#62;renderGrid(&#39;#grid&#39;,&#39;#pager&#39;,true, null, null, true,true);<br />$conn = null;</p>
<p>?&#62;</p>
]]></description>
        	        	<pubDate>Tue, 08 May 2012 00:40:27 +0300</pubDate>
        </item>
</channel>
</rss>