Sagewire Logo

CFGRID not displaying data

3 Message(s) by 2 Author(s) originally posted in flash and cfml


From: CF_Hack Date:   Friday, June 22, 2007
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
does not seem to work. Code below of a smaller grid that does not 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>


From: Chuck1411 Date:   Tuesday, June 26, 2007
Reason this one does not work is because you've two </CFGRID> closing tags.

You also do not 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.>


From: CF_Hack Date:   Tuesday, June 26, 2007
[q][i]Originally posted by: [b][b]Chuck1411[/b][/b][/i]
Reason this one does not work is because you've two </CFGRID> closing tags.

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

You also do not need to define the grid as format flash if the form is format
flash.

This does not matter since it does not 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. Does not 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 does not work



Next Message: Flash forms not working


Blogs related to CFGRID not displaying data

CFGrid Issue sort of resolved
SO now when I click Save, the database is updated but the grid columns being displayed are not refreshing. What do I need to do so that the data is refreshed in the display? Thanks, -- Bruce Sorge "I'ma mawg: half man, half dog. ...

Updating the database from CFGRID
Simple, by reducing the amount of steps it takes to add, edit, and manipulate data without giving a mess of confusion in one page. This is not so simple when it comes to CFGRID. There are a million examples of how to edit data within ...

Re: CFGrid data not showing
On 2/9/07, Michael Beins wrote: > I have never used cfgrid before, and I have followed the coldfusion mx 7 documentation examples, and I have read through some articles on the macromedias developer community on using cfgrid but I am ...

CFGRID & CFGRIDUPDATE - updating an array value before using ...
In the CFGRID, I am displaying fname, lname, and email as columns, and ownerid is in a column that is not displayed. The problem arises when I go to add a new record to the CFGRID, because there is no value for ownerid. ...

Re: CFGrid data not showing
A grid is generated but there is no data in it. It has colomun names and few empty rows. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create ...


Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional