cfgrid not displaying data

[tommyviper]

Ask your host to check the CFIDE mapping. I had a similar issue. It should be mapped by default, but sometimes it is not. Hope that helps!

[CF_Hack]

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>

[Chuck1411]

Reason this one doesn't work is because you have two </cfgrid> closing tags.

You also don't need to define the grid as format flash if the form is format
flash.

According to the docs, mask only works with Flash, not applet, wonder if that
is a typo. Pg 200 of Reference Vol 1.

And if you want the grid to use the QoQ all_oil2, you should specify that name
in the <cfgrid query tag.>

[CF_Hack]

[q]Originally posted by: Chuck1411
Reason this one doesn't work is because you have two </cfgrid> closing tags.

Typo. My code has a closing </cfform> tag

You also don't need to define the grid as format flash if the form is format
flash.

This doesn't matter since it doesn't work either way.

According to the docs, mask only works with Flash, not applet, wonder if that
is a typo. Pg 200 of Reference Vol 1.

That is correct. Doesn't matter still no data either way.

And if you want the grid to use the QoQ all_oil2, you should specify that name
in the <cfgrid query tag.>

Either way it doesn't work