<?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: sortableRows - how to use it? it's jQuery UI... i know</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know</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/sortablerows-how-to-use-it-its-jquery-ui-i-know/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>tony on sortableRows - how to use it? it's jQuery UI... i know</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12765</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12765</guid>
        	        	<description><![CDATA[<p>Hello,</p>
<p>It is not strange, but it is related to the nature of the grid and the jQuery UI sortable. Also not sure if this can be fixed easy.</p>
<p>Regards</p>
<p>Tony</p>
]]></description>
        	        	<pubDate>Sat, 05 Dec 2009 14:49:07 +0200</pubDate>
        </item>
        <item>
        	<title>attilaf on sortableRows - how to use it? it's jQuery UI... i know</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12721</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12721</guid>
        	        	<description><![CDATA[<p>thank you, it works now.</p>
<p>One issue i found with ordering. You can see it on <a title="My CMS video" href="http://www.youtube.com/watch?v=KWD3UNTocoI" target="_blank"></a><a href="http://www.youtube.com/watch?v" rel="nofollow" target="_blank">http://www.youtube.com/watch?v</a>.....WD3UNTocoI</p>
<p>As you can see, when i drag the first row to sort, something strange happens to the columns.</p>
]]></description>
        	        	<pubDate>Thu, 03 Dec 2009 17:56:17 +0200</pubDate>
        </item>
        <item>
        	<title>tony on sortableRows - how to use it? it's jQuery UI... i know</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12657</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12657</guid>
        	        	<description><![CDATA[<p>Hello,</p>
<p>Have missed your post - sorry.</p>
<p>Serialize would not work since we bind sortable to the table body of the grid</p>
<p>Also you can use getDataIDs&#160; method to obtain the ne id&#39;s after resorting, or use getRowData without parameter to get all rows</p>
<p>These are arays so you can serialize them and send it to server;</p>
<p><input type='button' class='sfcodeselect' name='sfselectit6061' value='Select Code' data-codeid='sfcode6061' /></p>
<div class='sfcode' id='sfcode6061'>
<p>jQuery(&#8221;#list&#8221;).jqGrid(&#39;sortableRows&#39;, <br />&#160;&#160; {<br />&#160; cursor: &#39;.handle&#39;,<br />&#160; update : function () {<br />&#160;&#160;&#160;&#160;&#160; var serial = jQuery(&#39;#list&#39;).jqGrid(&#39;getRowData&#39;);</p>
<p>&#160;&#160;&#160;&#160;&#160;&#160; //serialize the array here<br />&#160;&#160; }<br />&#160;});</p>
</p>
</div>
<p>Regards</p>
<p>Tony</p>
]]></description>
        	        	<pubDate>Wed, 02 Dec 2009 15:59:10 +0200</pubDate>
        </item>
        <item>
        	<title>Attila F on sortableRows - how to use it? it's jQuery UI... i know</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12656</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12656</guid>
        	        	<description><![CDATA[<p>anybody? <img class="spSmiley" style="margin:0" title="Smile" src="/blog/wp-content/forum-smileys/sf-smile.gif" alt="Smile" /></p>
]]></description>
        	        	<pubDate>Wed, 02 Dec 2009 15:49:57 +0200</pubDate>
        </item>
        <item>
        	<title>Attila F on sortableRows - how to use it? it's jQuery UI... i know</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12620</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/sortablerows-how-to-use-it-its-jquery-ui-i-know#p12620</guid>
        	        	<description><![CDATA[<p>Really great plugin, i use it in my CMS, thanks for creating this.</p>
<p>One question: I&#39;m having hard time here to implement the sortableRows feature.</p>
<p>I&#39;d like to see a demo on how to read the grid&#39;s sorted values, also some useability best practice (row sorting is relevant if the sorted column is the &#39;position&#39; column).</p>
<p>What i&#39;m trying to do here is (but serial is undefined):</p>
</p>
<p>&#160; jQuery(&#8221;#list&#8221;).jqGrid(&#39;sortableRows&#39;, <br />&#160;&#160;&#160; &#160;&#160;&#160; &#160; {<br />&#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160;&#160; cursor: &#39;.handle&#39;,<br />&#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; update : function () {<br />&#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; var serial = jQuery(&#39;#list&#39;).sortable(&#39;serialize&#39;);<br />&#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; alert(serial);&#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; <br />&#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; }<br />&#160;&#160;&#160; &#160;&#160;&#160; &#160; }<br />&#160; &#160;&#160;&#160; );</p>
</p>
<p>Then I would get the pages first items offset, send the offset and the serialized id&#39;s to the server and make :</p>
<p>i =0;</p>
<p>foreach(id from my post) {</p>
<p>update test_table set position = offset + i where tableid = id;</p>
<p>// offset is a positive number equal to the position of the first item on current page</p>
<p>i++;</p>
<p>}</p>
</p>
<p>another way is to somehow find out what id was inserted in front of what id, send both to server, then make some updates in the database.</p>
<p>Could someone please provide me a practical example on how to read the sort values?</p>
<p>Thanks.<img class="spSmiley" style="margin:0" title="Cool" src="/blog/wp-content/forum-smileys/sf-cool.gif" alt="Cool" /></p></p>
]]></description>
        	        	<pubDate>Tue, 01 Dec 2009 20:16:54 +0200</pubDate>
        </item>
</channel>
</rss>