<?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: jqgrid default value adding  a new record</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/jqgrid-default-value-adding-a-new-record</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/jqgrid-default-value-adding-a-new-record/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>fistaff on jqgrid default value adding  a new record</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/jqgrid-default-value-adding-a-new-record#p24784</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/jqgrid-default-value-adding-a-new-record#p24784</guid>
        	        	<description><![CDATA[<p>In my jqgrid I have a list of invoices, adding a new invoice I want that the field customerID assume a value.</p>
<p>This is the sql:</p>
<p>SELECT Customers.CustomerID,<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; Invoices.FaID, Invoices.FaCustomerID,<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; Invoices.InvoiceNumber,<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; Invoices.InvoiceData<br />&#160;&#160;&#160;&#160;&#160;&#160;FROM&#160;Customers<br />&#160;&#160;&#160;&#160;&#160;&#160;LEFT JOIN Invoices ON Customers.CustomerID=Invoices.FaCustomerID<br />&#160;&#160;&#160;&#160;&#160;&#160;WHERE<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; Customers.CustomerID= &#39;.$_SESSION["ID"]</p>
</p>
<p>I want in field Invoices.FaCustomerID the value of&#160; Customers.CustomerID</p>
</p>
<p>In my grid Customers.CustomerID and Invoices.FaCustomerID are hidden fields</p>
</p>
<p>thanks<br />&#160;&#160;&#160;&#160;&#160;&#160;</p>
]]></description>
        	        	<pubDate>Sat, 01 Oct 2011 17:57:51 +0300</pubDate>
        </item>
</channel>
</rss>