Updating CFGrid using cfquery

Question

Hello,
I am trying to have a dynamic cfgrid that changes content
based on a form button click.

Here's what i am trying to do:

I have a cfquery defined and this is bind to the cfgrid
&lt;cfquery name=&quot;GetParks&quot; ..&gt; 
SQL QUERY
&lt;/cfquery&gt;

&lt;cfgrid name=&quot;listingGrid&quot;
query=&quot;GetParks&quot;
rowheaders=&quot;false&quot; maxRows=&quot;50&quot;
height=480 selectMode=&quot;EDIT&quot;&gt;

All is well so far. In the same uber-form is contained a
button with a onclick function
&lt;cfformgroup type=&quot;horizontal&quot;
style=&quot;horizontalAlign:center&quot;&gt;
 &lt;cfinput type=&quot;button&quot;
name=&quot;submit&quot; value=&quot;Update
Screen&quot; onclick=&quot;submitSearch()&quot;
/&gt;

In submitSearch() function, I am trying to create a new query
and assigning the output to cfgrid to update:
function submitSearch():Void
{
 var listingGrid:mx.controls.DataGrid = listingGrid;
 &lt;cfquery name=&quot;updatequery&quot;&gt;
... &lt;/cfquery&gt;

listingGrid = ***HOW DO I ASSIGN THE OF THE NEW updatequery
**?
}

Thanks in advance,

bizgene · Answer

Sorry, I see that all my code snippets have been html escaped to quote etc.

In essence, I defined a query, then bind it to a cfgrid. The data shows up okay. Next I wanted to add a button which when clicked refreshes the grid with output from a modified query.

In order to achive that, I defined a new query in the function being called on click, but I am stuck with how to assign the output of the query back to the cfgrid.

listingGrid = what do i put here? just putting queryname or something else doesnt seem to work.
Thnx,.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded