CFGRIDCOLUMN value/valuedisplay 1

[Zan91]

I'm attempting to create a datagrid that has a select list filter that filters the data grid. Within the data grid I would like to have a dropdown listbox for looking up a foreign key value (the same element that was filtered the data grid to begin with)

It seems that within a cfgridcolumn you can use value= and valuedisplay= to make an element a select list. I can never get my page to display anymore than an editable cell. Is there something I'm missing? I would really like this to pull from a query but I left some sample code below (that I expected to work but does not)

<cfgrid name="gridBuildings"
height="400"
query="getBuildings"
appendkey="yes"
griddataalign="left"
gridlines="yes"
rowheaderalign="left"
colheaderalign="left"
selectmode="edit"
enabled="yes"
visible="yes"
format="flash"
autowidth="true">

<cfgridcolumn name="BuildingID" header="BuildingID" display="no">
<cfgridcolumn name="SiteID" header="SiteID" values="1, 2, 3" valuesdisplay="Site1, Site2, Site3"[/color red]>
<cfgridcolumn name="BuildingShortName" header="Short Name">
<cfgridcolumn name="Buildingname" header="Building Name">
</cfgrid>

Like I mentioned, I would really like this to be values from a query result set but even the simple example doesn't work.

Any help would be appreciated.

 

[Zan91]

Is it possible to have a dropdown list box within a column in a datagrid?

 

[Zan91]

Appears not to be possible to add a dropdown to a cfgrid as flash.

 

[TamedTech]

Hello Zan,

Is this the sort of thing you are looking for?

http://www.4windswholesale.com/productshow.cfm

This uses flash remoting to build the query to populate the CF Grid.

If this is what you're looking for then let me know and i'll show you the code.

Thanks,

Rob