CF7 - Flash Grid

[Jak-S]

Hi, I have the code below which is supposed to display X number of grids in my
form (depending on the number of sections), each grid will display a list of
the "colours" related to that section.

However when the form is generated the "colour" column in every grid is
repeated the same number of times as the number of sections.

so if there is 3 sections then i will have the colour colum repeaded 3 times
(each exactly the same) and when you update one column the other 2 will update.

Why is it adding the columns more than once? Please help,
it will be greatly appreciated.

Jack


<cfquery name="getSections" datasource="#application.datasource#"
dbtype="odbc">
SELECT id AS sections_id, name AS sections_name, viewOrder AS
sections_viewOrder
FROM sections
ORDER BY viewOrder
</cfquery>
<cfquery name="getColours" datasource="#application.datasource#" dbtype="odbc">
SELECT id AS colours_id, name AS colours_name, sectionID AS colours_sectionID
FROM colours
WHERE productID = #id#
</cfquery>

.......some other code.........

<cfoutput query="getSections">
<cfformgroup type="hbox">
<cfformgroup type="vbox">
<cfformitem type="text">#sections_name# Colours</cfformitem>
<cfquery name="getColours_#sections_id#" dbtype="query">
SELECT colours_name AS colours_name, colours_id AS colours_id
FROM getColours
WHERE colours_sectionID = #sections_id#
</cfquery>
<cfgrid name="colours_#sections_id#" query="getColours_#sections_id#"
height="80" selectmode="edit">
<cfgridcolumn name="colours_id" display="no">
<cfgridcolumn name="colours_name" display="yes" header="Colour">
</cfgrid>
</cfformgroup>
</cfformgroup>
<cfformitem type="hrule" />
</cfoutput>

[Jak-S]

Hi,

Dont worry about this. I have decided to give up on the whole flash forms thing. Just not sutiable for anything i want to do.

Jack