<?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: DB Lookup for select box.</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/db-lookup-for-select-box</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/db-lookup-for-select-box/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>tony on DB Lookup for select box.</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/db-lookup-for-select-box#p1322</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/db-lookup-for-select-box#p1322</guid>
        	        	<description><![CDATA[<p>See this</p>
<p><a href="http://www.trirand.com/blog/?page_id=18/help/setting-the-editoption-value-field-for-a-select-box/page-1&#038;value=dynamic%25select%251&#038;search=2&#038;ret=all" rel="nofollow" target="_blank"><a href="http://www.trirand.com/blog/?p" rel="nofollow">http://www.trirand.com/blog/?p</a>.....38;ret=all</a></p>
</p>
<p>But there is a bug in setColProp -&#160; see this forum how to correct</p>
]]></description>
        	        	<pubDate>Tue, 29 Jul 2008 11:11:59 +0300</pubDate>
        </item>
        <item>
        	<title>michael_echlin on DB Lookup for select box.</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/db-lookup-for-select-box#p1321</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/db-lookup-for-select-box#p1321</guid>
        	        	<description><![CDATA[<p>Hi</p>
<p>Thanks for this great looking plugin.</p>
<p>Ive only just started using this plugin and apologies if this has been</p>
<p>explained already. Im trying to grab my select box lookups in a seperate</p>
<p>get query and then just add the variable to relavent colModel line. Is</p>
<p>this even possible. I cant get it to work anyway.</p>
<p>$(document).ready(function(){<br />var chainvar;&#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160; <br />$.get("inc/asp/ajaxChainLookup.asp", function ( data ){<br />&#160;&#160;&#160; &#160;&#160;&#160; chainvar = data;<br />&#160;&#160;&#160; })<br />var artworker = $("#arthidden").val();&#160;&#160;&#160; <br />var datequery = $("#hiddendate").val();<br />var lastcellstate;<br />$("#navgrid").jqGrid({<br />&#160;&#160; &#160;&#160;&#160; url:&#39;inc/asp/ajaxGridLookup.asp?artworker=&#39; + artworker + &#39;&#38;dateofjob=&#39; + datequery,<br />&#160;&#160;&#160; datatype: "xml",<br />&#160;&#160; &#160;&#160;&#160; colNames:[&#39;ID&#39;, &#39;Chain&#39;, &#39;JobType&#39;, &#39;Duration&#39;],<br />&#160;&#160; &#160;&#160;&#160; colModel:[<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;ID&#39;,index:&#39;ID&#39;, width:55,editable:false,editoptions:{readonly:true,size:10}},</p>
<p>Attempted to add the variable in here as chainvar:-</p>
<p>&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;chain&#39;,index:&#39;chain&#39;, width:100,editable:true,edittype:&#39;select&#39;,editoptions:{value:chainvar}}, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;jobtype&#39;,index:&#39;jobtype&#39;, width:200,editable:true,editoptions:{size:25}},<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;duration&#39;,index:&#39;duration&#39;, width:60,editable:true,editoptions:{size:10}}],<br />sortname: &#39;ID&#39;, <br />sortorder: "desc",<br />onSelectRow: function(id){ if(id &#38;&#38; id!==lastcellstate)<br />{ jQuery(&#39;#navgrid&#39;).restoreRow(lastcellstate); <br />jQuery(&#39;#navgrid&#39;).editRow(id,true); lastcellstate=id; } }, <br />editurl: "ajaxGridUpdate.asp",<br />viewrecords: true, <br />imgpath: &#39;inc/themes/coffee/images&#39;, <br />caption: &#39;Grid&#39; <br />}); <br />});</p>
</p>
<p>I just get an <span class="objectBox objectBox-errorMessage hasTwisty hasBreakSwitch">options.value is undefined error,&#160; </span></p></p>
]]></description>
        	        	<pubDate>Tue, 29 Jul 2008 11:02:18 +0300</pubDate>
        </item>
</channel>
</rss>