<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:clearspace="http://www.jivesoftware.com/xmlns/jive/rss" version="2.0">
  <channel>
    <title>Adobe Community: Message List - Getting cfgrid (flash) to submit a row</title>
    <link>https://forums.adobe.com/community/coldfusion/coldfusion_flash_integration?view=discussions</link>
    <description>Most recent forum messages</description>
    <language>en</language>
    <pubDate>Tue, 14 Jan 2014 09:28:25 GMT</pubDate>
    <generator>Jive Engage 7.0.0.1  (http://jivesoftware.com/products/)</generator>
    <dc:date>2014-01-14T09:28:25Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>Re: Getting cfgrid (flash) to submit a row</title>
      <link>https://forums.adobe.com/message/6010356?tstart=0#6010356</link>
      <description>&lt;!-- [DocumentBodyStart:2c8afd12-7fdd-4a90-90b4-9b7c73669b19] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;It works for me! I reproduced your scenario as follows.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;em&gt;testForm.cfm&lt;/em&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;!--- The table animals has 2 columns (id, common_name) and 3 rows ---&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfquery name="session.allDefects" datasource="cfmx_db"&amp;gt;&lt;/p&gt;&lt;p&gt;select *&lt;/p&gt;&lt;p&gt;from animals&lt;/p&gt;&lt;p&gt;&amp;lt;/cfquery&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfform name="logForm"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfgrid name="propOppGrid" height="500" selectmode="row" autowidth="true" format="flash" query = "session.allDefects" onchange="getUrl('cqStatus_s1.cfm?CFGRIDKEY='+propOppGrid.selectedItem.id, '_blank');" /&amp;gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/p&gt;&lt;p&gt;&amp;lt;/cfform&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&lt;em&gt;cqStatus_s1.cfm&lt;/em&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;cfdump var="#url#"&amp;gt;&lt;/p&gt;&lt;p&gt;Query string: &amp;lt;cfdump var="#CGI.QUERY_STRING#"&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The grid displays as expected. When I click on a row, the page &lt;em&gt;cqStatus_s1.cfm &lt;/em&gt;pops up, displaying the id corresponding to the row. You might like to know that I am on ColdFusion 10.0.13.287689.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:2c8afd12-7fdd-4a90-90b4-9b7c73669b19] --&gt;&lt;img src='/beacon?t=1415918243195' /&gt;</description>
      <pubDate>Tue, 14 Jan 2014 09:28:25 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/message/6010356?tstart=0#6010356</guid>
      <dc:date>2014-01-14T09:28:25Z</dc:date>
      <clearspace:dateToText>9 months 1 month ago</clearspace:dateToText>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
    <item>
      <title>Getting cfgrid (flash) to submit a row</title>
      <link>https://forums.adobe.com/message/5731132?tstart=0#5731132</link>
      <description>&lt;!-- [DocumentBodyStart:b072f035-23b9-4e83-b314-37a14cccb590] --&gt;&lt;div class="jive-rendered-content"&gt;&lt;p&gt;Hi all,&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;I'm at about my wits end on this...I can submit a row from a query set in cfgrid if I set it to format=html and it works just fine.&amp;nbsp; However, with that format, I cannot sort columns which is necessary.&amp;nbsp; So, I set format=flash and the formatting works great, but I cannot submit a row for processing.&amp;nbsp; I've searched Google, Google Groups, Adobe, everyplace to no avail.&amp;nbsp; Plenty of "Working" solutions, but none work for me.&amp;nbsp; Below is the latest attempt:&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;lt;cfform name="logForm"&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;cfgrid name="propOppGrid" height="500" selectmode="row" autowidth="true" format="flash" query = "session.allDefects" onchange="getUrl('cqStatus_s1.cfm?CFGRIDKEY='+propOppGrid.selectedItem.id, '_blank'); "&amp;gt;&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;The query does indeed have a row called "ID" and it does display properly in the grid itself.&amp;nbsp; When I submit the form (which does indeed open up a new window ('_blank'), I get the following on my url and a blank page is displayed.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;"cqStatus_s1.cfm?CFGRIDKEY=undefined"&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;If I put the ID into the url manually, the data on that page will display properly.&amp;nbsp; I've tried other query column names (checking for the possibility that ID is reserved) with the same results.&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;VERY FRUSTRATED!!!!&lt;/p&gt;&lt;p style="min-height: 8pt; padding: 0px;"&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;Any help is GREATLY appreciated.&lt;/p&gt;&lt;/div&gt;&lt;!-- [DocumentBodyEnd:b072f035-23b9-4e83-b314-37a14cccb590] --&gt;</description>
      <pubDate>Wed, 02 Oct 2013 14:48:17 GMT</pubDate>
      <author>forums_noreply@adobe.com</author>
      <guid>https://forums.adobe.com/message/5731132?tstart=0#5731132</guid>
      <dc:date>2013-10-02T14:48:17Z</dc:date>
      <clearspace:dateToText>1 year 1 month ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
      <clearspace:objectType>0</clearspace:objectType>
    </item>
  </channel>
</rss>

