Question
cfgrid not displaying data
I'm using cfgrid to display a query of queries. cfgrid as
type applet displays everything perfectly. as flash only two
columns display. Also i can't change the format of the number in
flash while I can in applet. The mask attribute doesn't seem to
work. Code below of a smaller grid that doesn't work either.
query
<CFQUERY DBTYPE="query" NAME="all_oil">
SELECT get_total_oil.yyyy, get_total_oil.ievalue as total, get_crd_prod.ievalue as crude
FROM get_total_oil,get_crd_prod
where get_total_oil.yyyy=get_crd_prod.yyyy
order by YYYY
</CFQUERY>
<CFQUERY DBTYPE="query" NAME="all_oil2">
SELECT all_oil.yyyy, all_oil.total,all_oil.crude , get_conc.ievalue as conc
FROM get_conc, all_oil
where all_oil.yyyy=get_conc.yyyy
order by YYYY desc
</CFQUERY>
<cfform format="flash">
<cfgrid format="flash" query="all_oil" name="test" >
<cfgridcolumn name="yyyy" header="Year" width="40">
<cfgridcolumn name="total" header="Total Oil Production">
<cfgridcolumn name="crude" header="Crude Production" >
</cfgrid>
</cfgrid>
query
<CFQUERY DBTYPE="query" NAME="all_oil">
SELECT get_total_oil.yyyy, get_total_oil.ievalue as total, get_crd_prod.ievalue as crude
FROM get_total_oil,get_crd_prod
where get_total_oil.yyyy=get_crd_prod.yyyy
order by YYYY
</CFQUERY>
<CFQUERY DBTYPE="query" NAME="all_oil2">
SELECT all_oil.yyyy, all_oil.total,all_oil.crude , get_conc.ievalue as conc
FROM get_conc, all_oil
where all_oil.yyyy=get_conc.yyyy
order by YYYY desc
</CFQUERY>
<cfform format="flash">
<cfgrid format="flash" query="all_oil" name="test" >
<cfgridcolumn name="yyyy" header="Year" width="40">
<cfgridcolumn name="total" header="Total Oil Production">
<cfgridcolumn name="crude" header="Crude Production" >
</cfgrid>
</cfgrid>
AdChoices